Oracle Apps Technical Interview Questions – Part 7

By | September 27, 2014

Following is List of articles for Oracle Apps Technical Questions

Alternatively, Go through the following Top 10 Oracle Apps Technical Questions

List of Oracle Apps Technical Interview Questions – Part 7

1. Which Method should be used to open form programmatically instead of open_form anf call_form and tell the reason?
2. What is the important point regarding Module Name and Frst Navigation Data Block for starting a new custom forms?
3. How to Disable Specific Menu Entries?
4. What are the XML Publisher Tables?
5. How to upload RTF Template from backend?
6. What is Request Security Group?
7. What is Function and Sub Functions in Oracle Apps?
8. How to Open a Form in query Only Mode?
9. Forms Package variables defined in its specification, is it visible to attached libraries and vice versa?
10. The value recorded in system.Last_record variable is of type?
11. Can a single canvas have multiple windows ?
12. What ERASE package procedure does ?
13. What is Object Group ?
14. A query fetched 10 records How many times does a PRE-QUERY Trigger  and POST-QUERY Trigger will get executed ?
15. Can a root window be made modal?
16. Can we make a display item as database item?
17. What are bind parameter and lexical parameter used for?
18. Name few Oracle Forms Triggers that are changed in Oracle Apps?
19. What are the property classes for the following in Oracle Apps?
20. how to populate list dynamically?

1. Which Method should be used to open form programmatically instead of open_form anf call_form and tell the reason?

FND_FUNCTION.EXECUTE should be used instead of CALL_FORM or OPEN_FORM whenever there is need to open a form programmatically.

FND_FUNCTION.EXECUTE allows to open forms without bypassing Oracle Applications security, and takes care of finding the correct directory path for the form.

Back to top

2. What is the important point regarding Module Name and Frst Navigation Data Block for starting a new custom forms?

Module Names
Make sure that in each of your forms, the Module Name matches the file name. For example, if a form is called POXPOMPO.fmb, make sure the Module Name (visible in Oracle Forms Developer) is POXPOMPO. This is especially important if you reference objects from your form. Zoom also relies on the Module Name being correct.

First Navigation Data Block
Set this property to the name of the first block that users visit when a form is run. Do not set to a WORLD or CONTROL block. This property also controls where the cursor goes after a CLEAR_FORM, as well as the default ”Action–>Save and Proceed” behavior.

Back to top

3. How to Disable Specific Menu Entries?

If for certain windows you want to disable some menu entries, use the APP_SPECIAL routines to do so. Enable and disable SAVE to control the ”File–>Save” and ”File–>Save and Enter Next” menu entries. Save is automatically disabled when you call APP_FORM.QUERY_ONLY MODE.

Back to top

4. What are the XML Publisher Tables?

PER_GB_XDO_TEMPLATES
XDO_DS_DEFINITIONS_B
XDO_DS_DEFINITIONS_TL
XDO_DS_DEFINITIONS_VL
XDO_LOBS
XDO_TEMPLATES_B
XDO_TEMPLATES_TL
XDO_TEMPLATES_VL
XDO_TRANS_UNITS
XDO_TRANS_UNIT_PROPS
XDO_TRANS_UNIT_VALUES

Back to top

5. How to upload RTF Template from backend?

Using XDO Loader,we can upload an RTF from backend.

Back to top

6. What is Request Security Group?

A request security group defines the concurrent programs, including requests and request sets that may be run by an application user under a particular responsibility.To set up request security, you define a request group using the Request Groups form. Using the Responsibilities form, you assign the request group to a responsibility. The request group is then referred to as a request security group.

Back to top

7. What is Function and Sub Functions in Oracle Apps?

A function is a part of an application’s functionality that is registered under a unique name for the purpose of assigning it to, or excluding it from, a responsibility.

There are two types of functions: form functions, and non–form functions. For clarity, we refer to a form function as a form, and a non–form function as a sub function, even though both are just instances
of functions in the database.

Form (Form Function):
A function that invokes a form. Form functions appear in the Navigate window and can be navigated to.

Subfunction (Non–Form Function):
A function that is executed from within a form. Subfunctions can only be called by logic embodied within a Form Function. Subfunctions do not appear in the Navigate window and cannot be navigated to.

Back to top

8. How to Open a Form in query Only Mode?

Enter the parameters you wish to pass to your function. Separate parameters with a space. For a form function, if you specify the parameter QUERY_ONLY=YES, the form opens in query–only mode.

Back to top

9. Forms Package variables defined in its specification, is it visible to attached libraries and vice versa?

A package variable defined in a form is not visible to any attached library; a variable defined in an attached library is visible to the form.

Back to top

10. The value recorded in system.Last_record variable is of type

a. Number
b. Boolean
c. Character.

Boolean

Back to top

11. Can a single canvas have multiple windows ?

No, we cant have more than one window for a single canvas but the reverse is possible ie; for a window we can attach any number of canvases

Back to top

12. What ERASE package procedure does ?

Erase removes an indicated global variable.

Back to top

13. What is Object Group ?

Object Group is a container for a group of objects. If you want to package related objects so you can copy or subclass them in other module

Back to top

14. A query fetched 10 records How many times does a PRE-QUERY Trigger  and POST-QUERY Trigger will get executed ?

PRE-QUERY fires once.
POST-QUERY fires 10 times.

Back to top

15. Can a root window be made modal?

No.

Back to top

16. Can we make a display item as database item?

No

Back to top

17. What are bind parameter and lexical parameter used for?

A bind reference replaces a single value or expression. To create a bind reference in a query, prefix the parameter name with a colon (:).

A lexical reference is a text string and can replace any part of a SELECT statement, such as column names, the FROM clause, the WHERE clause, or the ORDER BY clause. To create a lexical reference in a query, prefix the parameter name with an ampersand (&).

Back to top

 18. Name few Oracle Forms Triggers that are changed in Oracle Apps?

 

Traditional Function
Oracle Apps Equivalent Function
CALL_FORM
FND_FUNCTION.EXECUTE
EXIT_FORM
do_key(’EXIT_FORM’)
To exit the entire Oracle Applications suite, first call:
copy(’Y’,’GLOBAL.APPCORE_EXIT_FLAG’);
Then call:
do_key(’exit_form’);
SET_ITEM_PROPERTY
APP_ITEM_PROPERTY.SET_PROPERTY  APP_ITEM_PROPERTY.SET_VISUAL_ATTRIBUTE
GET_ITEM_PROPERTY
APP_ITEM_PROPERTY.GET_PROPERTY
OPEN_FORM
Use FND_FUNCTION.EXECUTE. This routine is
necessary for function security.Both OPEN_FORM and FND_FUNCTION.EXECUTE cause the POST–RECORD and POST–BLOCK triggers to fire.
CLEAR_FORM
Use do_key(’clear_form’). This routine raises
the exception FORM_TRIGGER_FAILURE if there is an invalid record.
COMMIT
do_key(’commit_form’)
VALIDATE
APP_STANDARD.APP_VALIDATE

Back to top

19. What are the property classes for the following in Oracle Apps?
Item Type
Property Class Name
Textual buttons
BUTTON
Iconic buttons
BUTTON_ICONIC
Text Items
TEXT_ITEM
Text Item as display Item
TEXT_ITEM_DISPLAY_ONLY
WHO Columns
CREATION_OR_LAST_UPDATE
Display Items
DYNAMIC_TITLE
Poplists
LIST
Option Groups
RADIO_GROUP
Check Boxes
CHECKBOX
LOV
LOV

Back to top

 

 20. how to populate list dynamically?
There are two ways either through record group by using this code 1 or by using code 2
Code 1
PROCEDURE Pop_List IS
/*
** Built-in: CREATE_GROUP_FROM_QUERY
**Example: Create a record group from a query, and populate it.
*/
         list_id ITEM;
list_name VARCHAR2(40) := ‘BLOCK3.item’;
rg_name VARCHAR2(40) := ‘Employee_Names’;
rg_id RecordGroup;
errcode NUMBER;
outcome NUMBER;
BEGIN
/*
** Make sure group doesn’t already exist
*/
list_id :=Find_Item(list_name);
rg_id := Find_Group( rg_name );
/*
** If it does not exist, create it and add the two
** necessary columns to it.
*/
IF Id_Null(rg_id) THEN
rg_id := Create_Group_From_Query( rg_name,’SELECT ENAME,ENAME FROM EMP’,FORM_SCOPE,200);
        END IF;
IF Not Id_Null(rg_id) THEN
delete_group(rg_id);
rg_id := Create_Group_From_Query( rg_name,’SELECT ENAME,ENAME FROM EMP’,FORM_SCOPE,200);
END IF;
/*
** Populate the record group
*/
errcode := Populate_Group_with_query( rg_id,’SELECT ENAME,ENAME FROM EMP’ );
IF errcode = 0 THEN
outcome := GET_GROUP_ROW_COUNT(rg_id);
Message(outcome);
END IF;
Clear_List(list_id);
Populate_List(list_id,rg_id);
END;
Code 2
ADD_LIST_ELEMENT : Adds a single element to a list item.
Add_List_Element(list_name VARCHAR2, list_index, NUMBER,list_label VARCHAR2, list_value VARCHAR2);
Prev Oracle Apps Technical Interview Questions – Part 6                                             Next Oracle Apps Technical Interview Questions – Part 8

Related Posts:

Oracle HRMS Interview Questions
Question of the Day
9 Steps to become Oracle Apps Consultant
How to create backend logging mechanism
Steps for creating custom form in Oracle Apps
Clear Global Cache in Oracle Apps
Profile Values in Oracle Forms Personalization
2 simple Steps to make a responsibility read only
Step to Register Discoverer Report
Hierarchy of OLM Tables