Interview Questions For Oracle Apps

Qns: How will you developed reports from scratch to Registrations.

Ans:

STEP1: Write Query according to Specs.

STEP2: Add User Parameter in Query.

STEP3: Design Data Model.

STEP4: Design Layout according to specs.

STEP5: Defined Mandatory Parameter P_CONC_REQUEST_ID in report.

STEP6: Use User exit in reports.

STEP7: FTP the report the appropriate top in reports/US folders.

STEP8: registered reports in Oracle Apps (Note Explain all steps of apps registrations)

Qns: What is Difference between D2k and APPS Reports?

Ans:

D2K	Apps Reports
No User Exit	User Exit
P_Conc_Request_id not Required	P_CONC_REQUEST_ID Mandatory Parameter

Qns: What is Format Trigger?

Ans: Format trigger is used to print conditionally printing of Layout. Format trigger return Boolean values.

Qns: What do you mean by Anchoring in Reports?

Ans : With the help of Anchoring Relative position of two objects will be fixed.

Qns: What are Reports Trigger and Their Firing Sequence?

Ans:

• BEFORE PARAMETER FORM
• AFTER PARAMETER FORM
• BEFORE REPORT
• BETWEEN PAGES
• AFTER REPORT

Qns: What do you mean by Confine Mode in Reports?

Ans : Confine Mode Means Locking of Frames. If Confine Mode is on then you can not move the Object outside the Frame. If it is off you can move the objects.

Qns: Whats is Difference between Formula Column, Summary and Placeholder Column.

Ans:

• Formula Column: Formula Column is used to compute Values. Formula Column always returns the Values.
• Summary Column: Summary Column is used for Calculating summary function like Sum, Max. Min, Count.
• Placeholder Columns: Placeholder Column is used to place the Variables.

Qns: Whats is Difference between and Lexical and Bind Parameter.

Ans:

Bind Parameter	Lexical Parameter
With the help of Bind Parameter You Can Pass Values.	With the help of Lexical Parameter You can pass string. You can pass lexical parameter in Select, From , Where Clause
Denoted by Colon	Denoted by Ampersand(&) sign

Qns: How will you Print Conditionally Layout in reports.

Ans: With the help of Format trigger.

For example code like:

IF :P_TYPE

Qns: How will you call Concurrent Program through Reports.

Qns: Whats are User Exit in Reports?

Qns: In Which Folder You will put the Report on the Server?

Qns : How will you Register the Reports?

Qns : What do you Mean by Token in Reports.

Qns : What are Various Default Type in Concurrent Programs?

Qns : What do you incompatibility in Concurrent Programs?

Qns: How will you Capture ORG_ID Dynamically in Concurrent Programs.

Qns : Suppose I have two Parameter Start Date and End Date and I want My Start Date should be lower then End Date. How will you Validate.

Qns : What are Various Execution Method in Concurrent Programs in executables.

Qns : What is Difference between Application Name Defined in Concurrent Program Executables and Concurrent Programs.

Qns : Whats is Mandatory Parameter to Register PL/SQL Procedure in Apps?

Qns: How will you Call Reports with in Reports?

Qns: What do you Mean by Incompatibility in Reports?

Qns : What is significance of Mandatory Parameter in P_CONC_REQUEST_ID?

Qns: How will you put Message in Log File?

Qns : How will you put Message of Reports in LOG Files.