Oracle Apps Interview Questions-9

Oracle Apps Interview Questions,Askhareeshblogspot.com

121)Why do we call FND SRWINIT from Before Report Trigger?
FND SRWINIT fetches concurrent request information and sets up the profile options. It must be included if one is using any ORACLE APPLICATION OBJECT LIBRARY features in his report (such as concurrent processing)


122)Why do we call FND SRWEXIT from After Report Trigger?
FND SRWEXIT frees all the memory allocations done in other Oracle Applications user exits. It must be included if one is using any ORACLE APPLICATION OBJECT LIBRARY features in his report (such as concurrent processing)


123) Why do we call FND FLEXSQL from the Before Report Trigger?
One need to pass the concatenated segment values from the underlying code combinations table to the user exit so that it can display appropriate data and derive any description and values from switched value sets as needed. One gets this information by calling the AOL user exit FND FLEXSQL from the before report Trigger. 


124. If u call the user exit FND FLEXSQL with MODE = “ WHERE” from the Before Report Trigger. What will it do?This user exit populates a lexical parameter that you specify with the appropriate SQL fragment at run time. You include this lexical parameter in the WHERE clause of the report query. This user exit is called once for each lexical to be changed.

125. If u call the user exit FND FLEXSQL with MODE = “ ORDER BY” from the Before Report Trigger. What will it do?This user Exit populates the lexical parameter that one specifies with the appropriate SQL fragment at run time. One includes this lexical parameter in the ORDER BY clause of the report query. This user exit is called once for each lexical to be changed.


126. How can we display flexfield segment values, descriptions, and prompts on the report?Create a formula Column. Call the user exit FND FLEXIDVAL as the formula for this column. This user exit automatically fetches more complicated information such as descriptions and prompts so that one does not has to use complicated table joins to the flex field tables.


127. Name some options of the FND FLEXSQL user exit?
CODE, APP_SHORT_NAME, OUTPUT, MODE, DISPLAY, SHOWDEPSEG, NUM or MULTINUM, TABLEALIAS, OPERATOR, OPERAND1, OPERAND2.


128. Describe CODE option of the FND FLEXSQL user exit?
Specify the flex field code for the report (for example, GL#, MCAT).


129. Describe the APP_SHORT_NAME option of the FND FLEXSQL user exit?
Specifies the short name of the application that owns the flex field (for example: SQLGL, INV).


130. Describe the OUTPUT option of the FND FLEXSQL user exit?
Specify the name of the lexical parameter to store the SQl fragment. One uses this lexical later in the report when defining the SQL statement that selects the flexfield values. the datatype of this parameter should be character.


131. Describe the MODE option of the FND FLEXSQL user exit?
Specify the mode to use to generate the SQL fragment .

valid mode are :
SELECT: Retrieves all segments values in an internal (non- displayable format).
WHERE: Restrict the query by specifying constraints on flexfield columns. The fragment returned includes the correct decode statement if one specifies MULTINUM. One must also specify an OPERATOR and OPERANDS.
HAVING: Same calling procedures and functionality as WHERE.
ORDER BY: Order required information by flexfield columns. The fragment Orders your flexfield columns and separates them with a comma. The fragment returned includes the correct decode statement, one specifies in MULTINUM.


132. Describe the DISPLAY option of the FND FLEXSQL user exit?
One uses the DISPLAY token with the MODE token . the DISPLAY parameter allows you to specify segments that represent specified flexfield qualifiers or specified segments numbers ,where the segment numbers are the order in that the segments appear in the flexfield window, not the segment number specified in the Define Key Segments form.


Eg. If your MODE is SELECT and you specify DISPLAY = “ALL” then the SELECT statement includes all the segments of the flexfield. . Similarly, if your MODE is WHERE and you specify DISPLAY = “ALL”, then your WHERE clause includes all segments.


133. Describe the SHOWDEPSEG option of the FND FLEXSQL user exit?
SHOWDEPSEG = “N” disables automatic addition of depended upon segments to the order criteria. The default is “Y”. This token is valid only for MODE = “ODER BY” In FLEXSQL.


134. Describe the NUM option of the FND FLEXSQL user exit?
Specify the name or lexical or source column that contains the flexfield structure information. If the flexfield uses just one structure, specify NUM only and use a lexical parameter to hold the value. If the flexfield uses multiple structures, specify MULTINUM only and use a source column to hold the value. The default value is 101.


135. Describe the TABLE ALIAS option of the FND FLEXSQL user exit?
You use TABLE ALIAS if your SELECT joins to other flexfield tables or uses a self – join. 



 


*/