Thursday 7 July 2011

User Exits

User Exit :
-----------
User_Exit is a facility given in reports, to transfer the execution of report from report builder to the 3GL.

1.SRW.USER_EXIT('FND SRWINIT');
It will capture profile values of the user when the report is executed from SRS window.
FND SRWINIt User_Exit will be called from Before Report Trigger.

2. SRW.User_Exit('FND SRWEXIT');
It will be called from After Report Trigger which frees the memory occupied by the parameters of the report.

Below User_Exit are used to capture the data which stored in segments of the tables. one user exit is used to capture the segment data and another is used to populate the data.

3. SRW.User_Exit('FND FLEXSQL
CODE = " "
NUM = " "
Appl_Short_Name=" "
Output=" "
Mode= " "
Display = " "');
Used for the Key Flex Fields and stored in the Before Report Trigger.


4. SRW.User_Exit('FND FLEXIDVAL
CODE = " "
NUM = " "
Appl_Short_Name=" "
DATA=" "
Value= " "
Mode= " "
Display = " "');
is used for the Key flex fields this user_exit is written in the Formula column.