1. What is Frame, Repeating frame and Anchor Objects?
A. Frame: It is a layout object, which will be used to place the object and objects will be
displayed only one time in the output
Repeating Frame: It is a layout object, which will be used to display the database
columns and other objects which will be displayed multiple times on the output.
Anchor Objects: It is a layout object which will be used to set the child object
horizontal and vertical position based on parent object.
2. What are System Parameters?
A. MODE: To set the report mode weather char(99% apps report)/Bit map(Xml pub).
ORIENTATION: Landscape or portrait.
DESTYPE: File, Screen,Printer,E-Mail , Fax.
DESFORMAT: .pdf,.html,.txt.
DESNAME: Printer name, Fax number, E-Mail Id.
CURRENCY
COPY
THOUSAND etc.
3. What is Bind Parameter and lexical parameter ? What is the difference?
A. Bind Parameter : Will be used to pass the value into the sql query ‘WHERE’ Clause.
Lexical Parameter: Will be used to replace the string inside of the query in any clause.
Lexical parameter will be character(min 600). When we are using Lexical parameters
in ‘FROM’ clause then we have to specify the default value.
Bind parameter noted with : .
Lexical Parameter noted with & .
4. When will we use the Lexical parameters in our application?
A. When we want to change the query(SELECT/ WHERE FROM/ORDER BY) query
Dynamically then we will use the Lexical Parameters.
5. Where we handle the Lexical Parameters in your application?
A. After Parameter form trigger we will assign the values.
6. Tell me Where u have used lexical parameters in Oracle Applications?
A. In Oracle Applications KFF Desc ‘Select ‘ Clause.
To Change the sort option dynamically.
7. What are report triggers?
A. Before Parameter Form Trigger
After Parameter Form Trigger
Before Report Trigger
Between Pages Trigger
After Report Trigger.
8. What is the sequence of Trigger Firing ?
A. Same Sequence Listed Above.
9. What is the difference between After Parameter Form Trigger and Before Report
Trigger?
A. After Parameter Form Trigger: We Can’t access data mode column values?
Before Report Trigger : We can access all pl/sql global variables and report level
Columns.
10. What is Format trigger, Validation Trigger, and Action Trigger?
A. Format Triggers: will be used to hide/display the layout object dynamically and it returns Boolean value(True-display, False-Hide).
Validation Triggers : Will be used to validate the report parameter values.
Action Triggers: When user select the button in the report layout if we want to execute the same pl/sql code then we will use the Action Triggers.
11. What is Drill Down report and Matrix Report?
A. Drill Down : Calling one report from another.
Matrix : A matrix report contains one row of labels, one column of labels and information in a grid format that is related to the row and column labels.
For matrix report at least we have to define 4 groups.
12. How to run a report from another report?
A. srw.run_report(d2k projects)
Fnd.request.submit_request (For Oracle Apps).
13. What is confine Mode and Flex Mode?
A. Confine Mode: It is alock mode. Which will be used to lock the child objects.
If we enable the confine mode we can’t move the child objects out side of parent objects.
OFF, then we can move the child objects out side of parent objects.
Flex Mode: ON : IF we increase/decrease the child objects then its parent object also increase/decrease.
OFF: The parent object will not get effect.
14. How to define Anchor?
A. By selecting the Parent and Child object, we will define the Anchor.
15. What are SRW Packages?
A. srw.message
srw.progrma_abort
srw.user_exit
srw..reference.
srw.do_sql
srw.get_page_number.
16. What is user_exit?
A. User_exit is a program which will be used to pass the control from report builder to 3rd generation language and get some information.
17. What is Summary Column,Formula Column and Place Holder Column?
A. Summary Column: It is a built in Function, Which we can apply at group level or report level.
Formula Column: It is a pl/sql function where we can write our logic and return some value.
Place Holder Column: It is also a function but it will be used to store the value , we can access the this across the report builder.
It will work like global variable.
18. What is data link and group by?
A. In Group By we can get the records which are matching with the child records.
In datalink we can give any condions like =,>,<.
19. What is Between Pages Trigger ?
A. If we want to change the output format dynamically then we will use this trigger.
It will run n-1 times. Ex. If no.of pages are 10 then it will run 10-1= 9times.
If we come reverse (From last page to first page) trigger will not be fired.
20. If we don’t have the parameter form wether parameter trigger will fire or not?
A. Yes.
21. Which trigger will not fire?
A. Between Pages Trigger will not fired, we have only one/zero page output.
22. What is program units ? difference between pl/sql object program units?
A. Program unit contains Procedures,functions,package specification and package body.
Difference:
Program units: will be saved in the file. We can access from current report only.
Pl/Sql: Will be saved in database. We can access from any report.
23. What is Pl/Sql Library?
A. It is a group of Program Units, We can attach the library to other report so thatwe can use the program units which are there in libraries.
24. What is .rdf an .rep?
A. .rdf = report definition file.
.rep= report executable program.
25. What are different Versions?
A. 2.5/6i/9i/10g.
26. How to create table from report?
A. srw.do_sql for any ddl command.
27. How to Develop Multiple Layouts in reports?
A. By using Format Triggers , We can change the report layout dynamically.
