FLEX FILED REPORTS -USER EXITS
USER EXITS: USER EXITS are the 3rd party programs (i.e. java,Pro*c, etc.) that we can link with our reports to perform a particular task.
We can link 3rd party programs with our reports with SRW.USER_EXIT ( Name_of_the_User_Exit)’. We can reference the input parameters in user exist with SRW.REFERENCE( input_parameters).
FND SRWINIT: This User Exit is used to initialize the report in the memory.
FND SRWEXIT: This User Exit is used to release the memory occupied by the program.
FND FLEXSQL: This User Exit is used to tailer the SELECT statement which returns a string . It is a concatenation of the segment columns of a particular structure.
Parameters:
Application Short Name: “SQLGL”
Code: “GL#”
Number: “P_STRUCTURE_ID”
Output: “P_FLEXDATA”
Note: Bind parameters can be mapped with only one column where as Lexical Parameters is a placeholder column which can be used to substitute string in the parameter.
Example:
SELECT P_FlexData CflexData, Jounal_Name,…,…,
FROM KFF, TRANS
WHERE KFG.CCID =TRANS.CCID
AND STRUCT_ID=:P_STRUCT_ID;
FND FLEXID_VAR: is user ti retrieve Value_Set_IDs of all the Segments based on a parameter Struture and also retrieves values and descriptions based on Value_IDS and Value_Set_IDs.
Application Short Name : “SQLGL”
Code : “GL#”
Number : “P_STRUCTURE_ID”
Data : “C_FLEXDATA”
Description : “:C_DESC”
It concatenates the Value Set IDs of Segments.
Next >> STEPS REQUIRED TO CREATE A SIMPLE FLEX FIELD REPORT
Filed under: AOL (Application Object Library ), ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, Reports, SQL
Leave a Reply
You must be logged in to post a comment.