1. when we open the form what are the triggers will be fired?
Ans.
PRE-FORM
PRE-BLOCK
PRE-RECORD
PRE-TEXT-ITEM
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
2.What are trigger level? what is the sequence of triggers sequence firing ? How to over ride the sequence?
Ans. Item Level
Record Level
Block Level
Form level
The trigger firing sequence is same as the order mentioned above.
To change this order
Using Trigger Property:
Execution hierarchy = Override(default)
Before
After
3. What are the types of canvases we have?
Ans. Content(Default)
Stacked
Horizontal Tool Bar
Vertical Tool Bar
Tab Pages.
4. What is default canvas and diff between stacked and content? When we will use Stacked canvas?
Ans. Content canvas is default canvas
Content Stacked
1. Without content we can't develop 1. Optional
the form
2. It will occupy the complete 2. Depends on the Requirement
place of window
3. We can't hide 3. We can hide/display.
Stacked canvas is used to hide/display the canvas dynamically.
5. How to develop Tabular forms in D2K?
Ans. By using Tab Canvas , we can develop the Tab Forms.
6. What are the Pre-query and Post-query trigger and What is the difference?
Ans.
Pre-query : Executes only one time before query the data
It will be used to change query dynamically change WHERE clause.
Post-query : Multiple times executes after query the data for every record it will executed once.
It will be used to display the Non-Database Items.
7. What are Property Clause and Visual Attributes?
Ans.
Property Clause:
Property clause is grouping any property.
We can't change Property Clause dynamically.
We can define triggers.
Visual Attributes:
Visual Attributes are group of look and feel properties.
We can change Visual Attributes dynamically by using
SET_VA_PROPERTY procedure.
We can't define triggers.
8. Can we write triggers on Property Clause?
Ans. Yes We can define triggers on Property Clause.
9. What is the difference between CALL_FORM,OPEN_FORM,NEW_FORM?
Ans.
CALL_FORM : This will be used to call another form.
Another form/New form will be opened
If we want to go back to the main form, we have to close the new form.
OPEN_FORM : This will be used to open Another/New form.
We can navigate to both(main & New) forms.
NEW_FORM : New form will be opened and Old form will be closed.
10. What are the Ways we can call the report from the form?
Ans. By using RUN_PRODUCT Procedure , We can call the report from the Form.
11. What is the difference between PRE-FORM and WHEN-NEW-FORM-iNSTANCE ?
Ans.
PRE-FORM: Before form open, It will be fired.
WHEN-NEW-FORM-INSTANCE: Form will be opened but cursor will not be placed.
12. Can we create table from Form If so how?
Ans.
Yes, We can create table from form.
By Using FORMS_DDL Procedure
Ex: FORMS_DDL('CREATE TABLE XX_NEW_123(EMPNO NUMBER(4),ENAME VARCHAR2(20))');
13. What is the difference between Standard Procedure and Form Procedure?
Ans.
Standard PL/SQL Procedure : Stored in database.
Form Procedure(Called Program units) : It will be stored in form file.
We can access from the current form.
If we want to access from another form we need
to create library and attach library to the
form, then only we can used.
14. what are object groups?
Ans. It is a group of objects like canvas,data block,window.
If we want to copy the canvas,block,window to another form then we will use
object group.
15. How to change Form Layout dynamically ?
Ans. By using stacked canvas, We can change the Form Layout dynamically.
16. What are the ways we can generate .fmx?
Ans.
For Windows
FILE--->Administrator--->Compile
For Linux/Unix
f45gen
f60gen
17. If cursor transfer from one text item to another text item then what is the
trigger sequence fire?
Ans.
PRE-TEXT-ITEM.
WHEN-NEW-ITEM-INSTANCE
WHEN-VALIDATE-ITEM ( When we change the value)
POST-TEXT-ITEM
18. When we create Master Detail form what are the triggers will gets created and
at what level and what are the name and What is the functionality?Ans.
Non-Isolated : We Can't delete master record,if child associated child records exist.
Isolated : We can delete master record, then there will not be any effect for the
associated child records.
Cascade : We can delete master record then automatically associated child records
Ans.
PRE-FORM
PRE-BLOCK
PRE-RECORD
PRE-TEXT-ITEM
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
2.What are trigger level? what is the sequence of triggers sequence firing ? How to over ride the sequence?
Ans. Item Level
Record Level
Block Level
Form level
The trigger firing sequence is same as the order mentioned above.
To change this order
Using Trigger Property:
Execution hierarchy = Override(default)
Before
After
3. What are the types of canvases we have?
Ans. Content(Default)
Stacked
Horizontal Tool Bar
Vertical Tool Bar
Tab Pages.
4. What is default canvas and diff between stacked and content? When we will use Stacked canvas?
Ans. Content canvas is default canvas
Content Stacked
1. Without content we can't develop 1. Optional
the form
2. It will occupy the complete 2. Depends on the Requirement
place of window
3. We can't hide 3. We can hide/display.
Stacked canvas is used to hide/display the canvas dynamically.
5. How to develop Tabular forms in D2K?
Ans. By using Tab Canvas , we can develop the Tab Forms.
6. What are the Pre-query and Post-query trigger and What is the difference?
Ans.
Pre-query : Executes only one time before query the data
It will be used to change query dynamically change WHERE clause.
Post-query : Multiple times executes after query the data for every record it will executed once.
It will be used to display the Non-Database Items.
7. What are Property Clause and Visual Attributes?
Ans.
Property Clause:
Property clause is grouping any property.
We can't change Property Clause dynamically.
We can define triggers.
Visual Attributes:
Visual Attributes are group of look and feel properties.
We can change Visual Attributes dynamically by using
SET_VA_PROPERTY procedure.
We can't define triggers.
8. Can we write triggers on Property Clause?
Ans. Yes We can define triggers on Property Clause.
9. What is the difference between CALL_FORM,OPEN_FORM,NEW_FORM?
Ans.
CALL_FORM : This will be used to call another form.
Another form/New form will be opened
If we want to go back to the main form, we have to close the new form.
OPEN_FORM : This will be used to open Another/New form.
We can navigate to both(main & New) forms.
NEW_FORM : New form will be opened and Old form will be closed.
10. What are the Ways we can call the report from the form?
Ans. By using RUN_PRODUCT Procedure , We can call the report from the Form.
11. What is the difference between PRE-FORM and WHEN-NEW-FORM-iNSTANCE ?
Ans.
PRE-FORM: Before form open, It will be fired.
WHEN-NEW-FORM-INSTANCE: Form will be opened but cursor will not be placed.
12. Can we create table from Form If so how?
Ans.
Yes, We can create table from form.
By Using FORMS_DDL Procedure
Ex: FORMS_DDL('CREATE TABLE XX_NEW_123(EMPNO NUMBER(4),ENAME VARCHAR2(20))');
13. What is the difference between Standard Procedure and Form Procedure?
Ans.
Standard PL/SQL Procedure : Stored in database.
Form Procedure(Called Program units) : It will be stored in form file.
We can access from the current form.
If we want to access from another form we need
to create library and attach library to the
form, then only we can used.
14. what are object groups?
Ans. It is a group of objects like canvas,data block,window.
If we want to copy the canvas,block,window to another form then we will use
object group.
15. How to change Form Layout dynamically ?
Ans. By using stacked canvas, We can change the Form Layout dynamically.
16. What are the ways we can generate .fmx?
Ans.
For Windows
FILE--->Administrator--->Compile
For Linux/Unix
f45gen
f60gen
17. If cursor transfer from one text item to another text item then what is the
trigger sequence fire?
Ans.
PRE-TEXT-ITEM.
WHEN-NEW-ITEM-INSTANCE
WHEN-VALIDATE-ITEM ( When we change the value)
POST-TEXT-ITEM
18. When we create Master Detail form what are the triggers will gets created and
at what level and what are the name and What is the functionality?Ans.
Non-Isolated : We Can't delete master record,if child associated child records exist.
Isolated : We can delete master record, then there will not be any effect for the
associated child records.
Cascade : We can delete master record then automatically associated child records
Dt : 15-Aug-2023:
**************
FAQ_Reports
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 andinformation 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.
Additional:
Reports6i:
1. What is Frame, Repeating frame and Anchor Objects?
· Frames are used to surround other objects and protect them from being overwritten or pushed by other objects.
· Repeating frames surround all of the fields that are created for a group’s columns.
· Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent.
2. What are SYSTEM Parameters?
· Background, copies, currency, decimal, desformat, desname, destype, mode, orientation, printjob, thousands.
3. What are Bind Parameter and Lexical Parameter and what is the diff?
· Bind references (or bind variables) are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date.
· Lexical references are placeholders for text that you embed in a SELECT statement.
4. When we will use Lexical Parameters?
· You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.
5. Where we will handle the Lexical parameters?
· Data Model – SQL Window
6. Tell me where u has used Lexical parameters in u r exp?
7. What are the report triggers?
· Before parameter form
· After parameter form
· Before report
· Between pages
· After report .
8. What is the sequence of triggers firing?
· Before parameter form
· After parameter form
9. What is the diff between After Parameter Form and Before Report Trigger?
10. What are Format and validation and action triggers?
A format trigger is a PL/SQL function executed before an object is formatted. A trigger can be used to dynamically change the formatting attributes (font and color) of the object.
Validation triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form.
Action triggers are PL/SQL procedures executed when a button is selected in the Runtime Preview. The trigger can be used to dynamically call another report (drill down) or execute any other PL/SQL.
11. How to call another report from report?
· By using SRW.RUN_REPORT (command_line CHAR) built in
12. What if confine mode and Flex Mode?
· When confine mode is on u cannot move the child object from its parent,
· When flex mode is on u can resize the child object according to its parent.
13. What are SRW Packages we have?
SRW.DO_SQL (DDL &DML STMT),
SRW.RUN_REPORT,
14. What is User Exit?
· User exit is used to transfer the control from report builder to 3gl program and vice versa.
15. What are Formula, Summary, and Placeholder column? Difference?
· A formula column performs a user-defined computation on another column(s) data
· A summary column performs group functions like avg(),sum(),max() on the fields and returns a single value.
· A Place holder column is used to declare Global variables in a report
16. What is the diff between Data link and Group by?
· Data links relate the results of multiple queries.
17. What is the purpose of Between Pages trigger?
· The Between Pages trigger fires before each page of the report is formatted, except the very first page.
18. If out put is 10 pages how many times between pages trigger will be
Fired? If cursors go from last page to first page weather the trigger
will be created?
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 andinformation 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.
Additional:
Reports6i:
1. What is Frame, Repeating frame and Anchor Objects?
· Frames are used to surround other objects and protect them from being overwritten or pushed by other objects.
· Repeating frames surround all of the fields that are created for a group’s columns.
· Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent.
2. What are SYSTEM Parameters?
· Background, copies, currency, decimal, desformat, desname, destype, mode, orientation, printjob, thousands.
3. What are Bind Parameter and Lexical Parameter and what is the diff?
· Bind references (or bind variables) are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date.
· Lexical references are placeholders for text that you embed in a SELECT statement.
4. When we will use Lexical Parameters?
· You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.
5. Where we will handle the Lexical parameters?
· Data Model – SQL Window
6. Tell me where u has used Lexical parameters in u r exp?
7. What are the report triggers?
· Before parameter form
· After parameter form
· Before report
· Between pages
· After report .
8. What is the sequence of triggers firing?
· Before parameter form
· After parameter form
9. What is the diff between After Parameter Form and Before Report Trigger?
10. What are Format and validation and action triggers?
A format trigger is a PL/SQL function executed before an object is formatted. A trigger can be used to dynamically change the formatting attributes (font and color) of the object.
Validation triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form.
Action triggers are PL/SQL procedures executed when a button is selected in the Runtime Preview. The trigger can be used to dynamically call another report (drill down) or execute any other PL/SQL.
11. How to call another report from report?
· By using SRW.RUN_REPORT (command_line CHAR) built in
12. What if confine mode and Flex Mode?
· When confine mode is on u cannot move the child object from its parent,
· When flex mode is on u can resize the child object according to its parent.
13. What are SRW Packages we have?
SRW.DO_SQL (DDL &DML STMT),
SRW.RUN_REPORT,
14. What is User Exit?
· User exit is used to transfer the control from report builder to 3gl program and vice versa.
15. What are Formula, Summary, and Placeholder column? Difference?
· A formula column performs a user-defined computation on another column(s) data
· A summary column performs group functions like avg(),sum(),max() on the fields and returns a single value.
· A Place holder column is used to declare Global variables in a report
16. What is the diff between Data link and Group by?
· Data links relate the results of multiple queries.
17. What is the purpose of Between Pages trigger?
· The Between Pages trigger fires before each page of the report is formatted, except the very first page.
18. If out put is 10 pages how many times between pages trigger will be
Fired? If cursors go from last page to first page weather the trigger
will be created?
No comments:
Post a Comment