Business Intelligence (BI) - ERP - Dashboards

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

Free Dashboards