Oracle Apps Technical Interview Questions – Part 2

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 2

1. When we Create a Responsibility for HR, What are three security profiles that should be set?
2. What is ALERT?
3. What is difference between concurrent program and concurrent request?
4. What is Multi Org?
5. How do you mail the output of a report?
6. What are the mandatory parameters given in Reports?
7. What are four steps needed to implement a user hook?
8. How can i know which application uses AME?
9. What is the p_validate control parameter?
10. Can I use an API on an application table on which an event-based alert is defined?

1. When we Create a Responsibility for HR, What are three security profiles that should be set?
HR: Business Group
HR:Security Profile
HR: User type

Back to top

2. What is ALERT?
Oracle Alerts are used to monitor unusual or critical activity in Oracle Apps database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from tablespace sizing to activities associated with particular applications.
There are two types of Alerts. 1- Periodic Alert 2- Event Based Alerts

Back to top

3. What is difference between concurrent program and concurrent request?
Concurrent program stores the definition of what needs to be run and what parameters it can accept where as concurrent request is submitting the concurrent program for output.

Back to top

4. What is Multi Org?
Multi-Org is an Oracle Financials feature that lets you identify specific data and financial transactions as belonging to a single organization – classified as an `Operating Unit’ within your enterprise. This is essential for large customers with multiple lines of business or divisions where you want to secure access to information and simplify processing and reporting.

Back to top

5. How do you mail the output of a report?
You can email output of a concurrent program either through PL/SQL or Shell script

Using PL/SQL: For this you can use UTL_SMTP package in your concurrent program to send the mail

Using Shell Script: Use MAILX called in a shell script registered as a concurrent program with parameters File name and path.For references refer to blog: http://oracle.anilpassi.com/email-output-of-concurrent-program-request-2.html

Back to top

6. What are the mandatory parameters given in Reports?
There is one parameter P_CONC_REQUEST_ID. If you want to use AOL functionality through user exits or you want to use profile values through FND_PROFILE.VALUE(), then above mentioned parameter must be defined.

Note: In case you don’t need to use above mentioned things, oracle apps report will work fine even if P_CONC_REQUEST_ID parameter does not exist in the oracle report.

Back to top

7. What are four steps needed to implement a user hook?
Four steps are required to implement API User Hooks:
1. Determine the API to which you need to hook extra logic
2. Write the PL/SQL procedure that executes your logic.
3. Register your procedure with one or more specific user hooks.
4. Run the pre-processor program that hooks your PL/SQL procedure to the hook(s).

For More Details on this topic, Click here

Back to top

8. How can i know which application uses AME?
we can check the user guide of the module or check the in the table.
select * from AME_CALLING_APPS_VL

Back to top

9. What is the p_validate control parameter?
Every HRMS API has a p_validate control parameter.
When the parameter is set to FALSE then all the business function validation is performed.If every thing is validated then row can be inserted/updated/deleted accordingly.

If p_validate is set to TRUE then only the actual operation is validated. A savepoint is issued at the start of the call and a rollback is done at the end of the call.

Back to top

10. Can I use an API on an application table on which an event-based alert is defined?
No, if an event-based alert defined on an application table then the API will give error. To run API the alert has to be disabled and re-enabled after the API has been executed.

Back to top

Prev Oracle Apps Technical Interview Questions – Part 1                                             Next Oracle Apps Technical Interview Questions – Part 3

Related Posts:

Question of the Day
HRMS Interview Questions
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