Oracle Apps Questions and Answers for D2k Reports, Report Triggers/ Formula Triggers

Oracle Apps Questions and Answers for D2k Reports, Report Triggers/ Formula Triggers /Before Parameter form Trigger /After Parameter form Trigger/Before Report Trigger /Between Pages Trigger/After Report Trigger ?

D2K REPORTS :

oracle apps interview questions ,Report Triggers/ Before Parameter form Trigger /After Parameter form Trigger/Before Report Trigger /Between Pages Trigger/After Report Trigger /d2k reports interview questions for fresher's frequently asked reports interview questions are given following.

         

17.What are the various types of report triggers and also define how they are firing ?

Ans. There are five types of Report Triggers they are

1.Before Parameter Form Trigger : Before Parameter Form Trigger will fires before the run time parameter form that will displayed on the screen ,by using Before Parameter form Trigger you can change the value of the parameters

 2.After Parameter form Trigger: After form Trigger will fires after runtime parameter form is displayed. by using After Parameter form Trigger  you can access parameters and check the values ,and also be used to change the parameter values .

3.Before Report Trigger : Before Report Trigger will fires before the report is execution but after queries are parsed and data is fetched .

4.Between Pages Trigger : Between Pages Trigger will fires before each page of the report is formatted (printed in layout ) ,except the very first page , Between Pages Trigger can be used for customized page formatting .

5.After Report Trigger : After Report Trigger will fires after you exit the previewer or after report layout is sent to specified destination, such as a file ,a printer , After Report Trigger can be used to clean up any initial processing that was done.

18. What are the Formula Triggers available in reports ?

Ans the formula triggers are three types they are

1. Action Triggers : Action Triggers are PL/SQL procedures , these are executed when a button is selected in the previewer ,the Action Triggers can be used dynamically call another report  or execute any other PL/SQL procedure.

2.Format Triggers : Format Triggers are PL/SQL functions ,these are executed before the objects is formatted , Format Triggers can be used to dynamically change the formatting attributes of the objects.

3.Validation Triggers : Validation Triggers are PL/SQL functions ,these are executed when parameter values are specified on the command  line and when you accept the runtime parameter form,

 that means Validation Triggers are fired twice when you execute the report .

19. How many times a between pages Trigger will fired ?

Ans  n-1 times ,

for example , if report output has 11 pages then the between pages trigger will be fired 10 .

 Tags : oracle apps interview questions,D2k Reports interview questions / D2k Reports  basics / oracle interview questions for fresher's /oracle D2k Reports / oracle apps interview questions  /oracle basic interview questions /D2k Reports /What Report Triggers /What Is Before Parameter Form Trigger, After form Trigger, Before Report Trigger /What Is Formula Triggers /how Many between pages trigger will be fired /What Is  /D2k Reports / D2k Reports / in D2k Reports What Is Action Triggers /D2k Reports in Oracle Apps.

Read More

Oracle interview questions on D2k Reports, summary columns/ placeholder column/ formula columns

SJA->Oracle interview questions on D2k Reports, what is summary columns/what is placeholder column/what is formula columns .

D2K REPORTS :

oracle applications interview questions ,d2k reports interview questions for freshers frequently asked reports interview questions are given following .

7.What is the difference between frame and repeating frame ?

Ans:  the difference between frame and repeating frame is ..

 frame is used to display the layout objects only one  time like  headings/titles and their filed values at once

Example:    

Name     job    sal   Raju       eng     30000

       

Repeating frames are used to display multiple record at a time ,that means multiple record are in layout then we        are using repeating frame .

Name      job         sal   Raju        jr.eng     20000   Ravi        sr.eng     40000     Niha       tech.sup  30000

         

8.What is summary column in reports ?

Ans : the summary columns are performs a calculations based on another column value ,the summary column data type should be depend on the source column .this summary column normally used for  calculating the sum averages and etc .

The summary columns are generally preceded by CS_ to differentiate them from other columns .

9. What is placeholder column in reports ?

Ans :the placeholder column is nothing but an empty container

Created at design time. This is populated at runtime, in other words the place holder column is name of the variable which can hold a calculated value (i.e summary ,average ),this place holder value are set by function and the pl/sql block only.

10. What is formula columns in reports ?

Ans :the formula column can perform a user defined  computations on the data of one or more other columns data .this formula column is a pl/sql function that returns a single value .

The formula columns are generally preceded by CF_ to differentiate them from other columns .

 Tags : (oracle apps ),D2k Reports interview questions / D2k Reports  basics / oracle interview questions for freshers /oracle D2k Reports / oracle basic interview questions /D2k Reports in oracle apps /What Is summary columns /What Is placeholder column /What Is formula columns /how Many Report Layout Types /What Is Frame  /D2k Reports Company / D2k Reports / D2k Reports What Is Repeating Frames /D2k Reports (oracle apps )

Read More

Oracle interview questions on D2k Reports, What Is Confine Mode /What Is Flex Mode

SJA->Oracle interview questions on D2k Reports, What Is Confine Mode /What Is Flex Mode .

D2K REPORTS :

oracle applications interview questions , What Is Confine Mode /What Is Flex Mode ,d2k reports interview questions for fresher's, frequently asked reports interview questions are given following .

1. What Is Confine Mode In D2k Reports ?

Ans: Confine Mode Is Used Child Objects Can Moving Over A Parent Objects,

Confine Mode On :When Confine Mode Is On The Child    Objects Cannot Be Moved Outside Of Their Enclosing Parent  Objects.

Confine Mode Off :When Confine Mode Is Off The Child   Objects Can Be Moved Outside Of Their Enclosing Parent  Objects.  

2. What Is Flex Mode In D2k Reports ?

Ans: Flex Mode Is Used To Resize The Border Of The Objects .

Flex Mode On: When Flex Mode Is On The Child Border   Size Is Changed, Automatically Parent Objects Size Also      Resized .

Flex Mode Off: When Flex Mode Is Off The Child Border   Size Is Resized , Then Parent Object Size Can't Be Resized ,It's Mean Is Fixed .

3.What Is An Anchor Objects In D2k Reports ?

Ans: Anchor Objects Are Used To Determine The Vertical And Horizontal Positioning Of A Child Object Relative To Its Parent Objects .

4.How Many Report Layout Types In Reports ,And What Are They ?

Ans: Tabular Reports ,Form Like Reports, Form Letter       Reports,Malling Label Reports, Group Left Reports ,Group Above Reports ,Matrix Label ,Matrix With Group.

5.What Is Frame In D2k Reports?

Ans :Frames Are Surround Other Layout Objects Allows Usto     Control Multiple Objects  Simultaneously .

 Tags : D2k Repots interview questions / D2k Repots  basics / oracle interview questions for freshers /oracle D2k Repots / oracle basic interview questions /D2k Repots /What Is Confine Mode /What Is Flex Mode /What Is An Anchor Objects /how Many Report Layout Types /What Is Frame  /D2k Repots Company / D2k Repots / D2k Repots   D2k Repots

Read More