Oracle Apps Technical Interview Questions – Part 3

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 3

1. Can AME send notifications?
2. How do we know whether AME is configured or not for a application?
3. What is the use of ID_FLEX_NUM?
4. How do i identify the Package name and version of the API?
5. What is Object version number and how do I assign values for it in an API?
6. What is the difference between org_id and organization_id?
7. What are user exits in reports and name a few?
8. How do you submit a concurrent program from PL/SQL Procedure?
9. What is RAISE_APPLICATION_ERROR used for?
10. What are the different cursors available in PL/SQL ?

1. Can AME send notifications?
AME doesn’t have any feature to send notifications.it is responsibility of calling application of sending notification, capturing the response and updating AME with response

Back to top

2. How do we know whether AME is configured or not for a application?
Check the profile AME installed at application level.It should be set to YES

Back to top

3. What is the use of ID_FLEX_NUM?
It is used to define the Structure Definition. The Structure Definition is held in FND_ID_FLEX_STRUCTURES table.

Back to top

4. How do i identify the Package name and version of the API?
SELECT text FROM all_source WHERE name like ‘HR_EMPLOYEE_API%’AND text LIKE ‘%Header%’;

Alternatively use the Integration Repository Responsibility (R12)

Better approach is to use the second option as it gives you quick way to find with detailed knowledge base about API signature parameters and default expected values in more readable format.

Back to top

5. What is Object version number and how do I assign values for it in an API?
Object Version number is an assigned number to a row in a database table. When a new row inserted its number is set to 1. If any updates performed on the row then the Object version number is incremented. Every API has the p_object_version_number control parameters.

For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.

For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory. You get the version number from the table record which is going to be updated and pass it to API, then API increments this Object version number.

Back to top

6. What is the difference between org_id and organization_id?
org_id refers to unique identifier for the Operating Units and organization_id refers to the unique identifier for Inventory Organizations.

Back to top

7. What are user exits in reports and name a few?
User exits provided a way to pass control from Reports Builder to a Oracle Apps environment. Using this we can get profile values in oracle reports which are set at application level for user running the report. Further through user exits, we can get Application Object Library data through standard user exit functions.

Another explanation of User Exits is

As the name indicates user exits are the programs written in any of the language like Java C++ Pro C to perform certain action. User exit when called from Report triggers moves the control from report to this outside program there it performs the action programmed and returns back to report environment.The program which makes USER to EXIT from ongoing environment to perform certain action is USER EXIT.

Names of User Exit are

1. FND SRWINIT
2. FND SRWEXIT
3. FND FORMAT_CURRENCY
4. FND FLEXIDVAL
5. FND FLEXSQL FND SRWINIT
6. FND SRWEXIT
7. FND FORMAT_CURRENCY
8. FND FLEXIDVAL
9. FND FLEXSQL

Back to top

8. How do you submit a concurrent program from PL/SQL Procedure?
FND_REQUEST.SUBMIT_REQUEST()

Back to top

9. What is RAISE_APPLICATION_ERROR used for?
The RAISE_APPLICATION_ERROR is a procedure defined by Oracle that allows to raise an exception and associate an error number and message with the procedure.

Back to top

10. What are the different cursors available in PL/SQL ?
Explicit Cursors, Implicit Cursors, Ref Cursors

Back to top

Prev Oracle Apps Technical Interview Questions – Part 2                                             Next Oracle Apps Technical Interview Questions – Part 4


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