Top 10 Oracle Apps Technical Interview Questions

By | July 30, 2014

These are Top 10 frequently asked questions for Oracle Apps interviews.
Following is List of articles for Oracle Apps Technical Questions

 

List of Top 10 Oracle Apps Technical Interview Questions

1. What are the steps to register Concurrent Program?
2. What are different triggers that can be used in personalization?
3. How do you move personalization from one instance/database to other?
4. What are different report triggers and what is their firing sequence ?
5. What are global variables ? How they can be used ?
6. What are custom events in apps and how to you enable/disable it?
7. What is the difference between having personalization at function level rather than form level?
8. How to attach reports in Oracle Applications ?
9. What are the steps for creating a custom Form in Apps
10. What is the difference between Key flex field and Descriptive flex field?


1. What are the steps to register Concurrent Program?

1. Define the Executable
2. Define the Concurrent Program for the above Executable
3. Attach the Concurrent program to a Request Group

Steps to Register Concurrent Program 1
Back to top

2. What are different triggers that can be used in personalization?

WHEN-NEW-FORM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
WHEN-VALIDATE-RECORD
MENUS SPECIAL EVENTS
Back to top

3. How do you move personalization from one instance/database to other?

Forms Personlizations can be moved easily through FNDLOAD from one instance to other.
Back to top

4. What are different report triggers and what is their firing sequence ?

There are five report trigger :
1. Before Report
2. After Report
3. Before Parameter Form
4. After Parameter Form
5. BetweenPages

The Firing sequence for report triggers is Before Parameter Form – After Parameter Form – Before Report – Between Pages – After Report.
Back to top

5. What are global variables ? How they can be used ?

Global variables are variables with more scope which is at the application level. They can be used in Form personalizations, PL/SQL procedures , reports e.t.c
Back to top

6. What are custom events in apps and how to you enable/disable it?

Custom Events are used to track and see which trigger is fired at what point in oracle forms. This can be enabled by going to Help -> Diagnostics -> Custom Code -> Show custom events
Back to top

7. What is the difference between having personalization at function level rather than form level?

A Form can have multiple functions. Having the personalization at function level limits the scope of the personalization. For example in Inventory for both “Master Item form” and “Organization Item form” uses same form named INVIDITM where as both have different functions linked to them.
Back to top

8. How to attach reports in Oracle Applications ?

The following 6 steps are needed:
1. Design your report in D2K
2. Generate the executable file of the report as .rdf.
3. Move the executable as well as source file to the appropriate product’s folder.
4. Register the report as concurrent executable.
5. Define the concurrent program for the executable registered.
6. Add the concurrent program to the request group of the responsibility.
Back to top

9. What are the steps for creating a custom Form in Apps?

Steps to Develop Custom Form in Oracle Apps

Steps to Develop Custom Form in Oracle Apps

1.  Copy template.fmb form from AU_TOP and rename it
2.  Change the when new form instance and replace name of form with your forms’s name. Lets assume form name is XX_EMPLOYEE
3.  It is always better to use newblock/canvas and window of your own and then subclass it
4.  Write the window name in app_custom.close_window procedure to close your form on clicking the close button. Code should look like this

if (wnd = ‘XX_EMPLOYEE’) then
app_window.close_first_window;
elsif (wnd = ”) then
end if;

5.  In Form Module Property, Set the First Navigational Block to any of your Data Block
6.  In Pre- Form Trigger, set the Window Name

app_window.set_window_position(‘ALERT_CONC_REG’, ‘FIRST_WINDOW’);

7. Move your Data Block/Canvas/Window as first block in the data block/Canvas/ Windows section respectively
8.  Set the canvas name for from window properties pallet
9. Save the Form and put it the AU_TOP folder
Compile the form and make sure that form is placed in the specific application TOP folder. Read Full Article on Custom Form
Back to top

10. What is the difference between Key flex field and Descriptive flex field?

Key Flex field

Descriptive Flex field

1. They are Unique Identifiers of an entity
1.It is used to capture extra information related to an entity.
2. Key Flexfields are stored in segment columns.
2. They are stored in attributes columns of table
3. It is Based on Key Flex field and it is date tracked.
3. It is Based on DFF and is not date tracked
4. For key flexfield there are flexfield Qualifier and segment Qualifier
4. Context-sensitive flexfield is a feature
 of DFF. (descriptive flexfield)

Back to top

Next Oracle Apps Technical Interview Questions – Part 1


Related Posts:

9 Steps to become Oracle Apps Consultant
Hierarchy of OLM Tables
How to create backend logging mechanism
Step to Register Discoverer Report
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