Oracle Apps Interview Questions with Answer -Part 1

Oracle Apps  Interview Questions with Answer -Part 1

1. What is the use of CUSTOM Library in Oracle Apps?
        The CUSTOM library allows extension of Oracle Applications without modification of Oracle Applications code. You can use the CUSTOM library for customizations such as Zoom (such as moving to another form and querying up specific records), enforcing business rules (for example, vendor name must be in uppercase letters), and disabling fields that do not apply for your site.

2. What is profile Option ? What are the types of profile option
       The profile option acts like a Global Variable which controls the behavior of behavior of Oracle Apps.
     There are 2 types
       1. System Profile options: These are visible and can be updated only in System Administrator             responsibility.
       2. User Profile Options : These are visible and can be updated by any end user of Oracle Apps.

3. What are the levels of profile options and which level takes the precedence

• Site Level : It is restricted to the whole of Apps
• Application Level: It is restricted only to a particular application like Receivables, Payables .PO
• Responsibility Level : It is restricted only to a particular responsibility
• Organization Level : It is restricted to a particular organization
• User Level: restricted to a particular user

           If there are 2 profile options set then the lowest level takes the precedence.

4. What is value set? What are the types of value set.
       It is a set of values which can be used in the concurrent program to display the List of Values in the parameter.
There are six different types of Value sets available in Oracle Apps.
        1) Independent
        2) Dependent
        3) Table
        4) Special
        5) Pair
        6) None

 5. What is alert in oracle apps? What are the types of Alerts.
Alert is the concept which is used to notify a person /multiple person about any event or some data change.
There are 2 types of Alerts

•  Event based Alerts: These Alerts are triggered based on some change in data in the database. Eg: Insertion of any new row to a table or update any row in a table 
•  Periodic Alerts: These Alerts are triggered hourly, daily, weekly, monthly or yearly based on your input.

6. How to Register a custom tables in Oracle Apps?
By using the AD_DD package we can register custom tables and column in Oracle apps.

7. How do I open a form in Query Only Mode?
Navigate to the Form Functions form and Query the particular form. Add the parameter QUERY_ONLY=YES .
 

 8. How to submit a concurrent request from PL/SQl ?
   By using FND_REQUEST.SUBMIT_REQUEST we can submit concurrent requests from PL/SQL

 9. How to check the version/Release of the Oracle Application installed.
     SELECT release_name FROM fnd_product_groups

10. How to check any oracle bugs/Patched applied ?
       From AD_BUGS table we can check .
      SELECT bug_number FROM ad_bugs

 11. How to find the name of a form in oracle apps?
       Use Help->About Oracle Applications
      Scroll down to find the form name

 12. What is a Concurrent Program Executable?
An executable file that performs a specific task. The file may be a program written in a standard language, a reporting tool or an operating system language.
 

 13. List Any 5 tables in oracle Apps relating to AOL.
        Fnd_concurrent_programs
        Fnd_executables
        Fnd_concurrent_requests.
        fnd_responsibility 

       fnd_request_groups
 

14. What are the types of triggers in Oracle reports

• a. Report Triggers: These are activated in response to report events like report opening /closing
• b. Format triggers: These are executed before an object is formatted.
• c. Validation Trigger: These are pl/sql functions that are executed when parameter values are specified on command line and you accept the runtime parameter form .

 15. What are types of report triggers in oracle reports and the sequence of firing .

• 1. Before parameter form,
• 2. After Parameter form
• 3. Before report
• 4. Between Pages
• 5. After report

 16. How to migrate AOL objects from One instance to Another.

  Using FNDLOAD we can migrate AOL Objects from one instance to Another .
 

 17. What is User exits in oracle apps reports. List few of them.
      User exits is used to integrate Oracle reports with Oracle Application Object Library, and run them as concurrent programs from your forms or through standard request submission.
User Exits in the reports are:

• FND SRWINIT
• FND SRWEXIT
• FND FORMAT_CURRENCY
• FND FLEXIDVAL
• FND FLEXSQL

18. What are the columns in Oracle reports ?

• a. Place holder column
• b. Formula Column
• c. Summary Column

19. Steps to register an RDF reports in Oracle Apps.

• 1. Create Executables for the RDF
• 2. Create concurrent Program for the Executable
• 3. Find the request group attached to the responsibility
• 4. Attach the concurrent Program to the request group

20. List down some Base tables for O-C cycle

• Oe_order_headers_all
• Oe_order_lines_all
• Wsh_delivery_details
• Wsh_delivery_assignments
• Wsh_new_delivery
• Ra_customer_trx_all
• Ra_customer_trx_lines_all

21. Sequence of firing triggers in form.

• a. Pre-form
• b. When-new-form
• c. pre-block
• d. when-new-block-instance
• e. when-new-record-instance
• f. when-new-item-instance
• g. Post-block
• h. post-form

22. Once you query a form how many times below triggers will be triggered?
       a. Pre-query
       b. Post-query
        Pre-query will be triggered one time.
        Post-query will be triggered for each record.

23. How to delete a concurrent program and concurrent Executables in Oracle apps.
Concurrent program cannot be deleted from Oracle Applications front-end, it can only be disabled.
We can delete by using fnd_program.delete_program from back end.
 

24. What is a record Group?
A record group is an oracle forms data structure that has a column/row framework similar to a database table.
 

25. I am using a host to send the emails. I have developed that email logic in different way i.e in pl/sql,workflow, alerts. If the host crashed how could I send the mail to the destination?
If we use lookups for the host name and after change the lookup values to new host name .