SRW.USER_EXIT (‘FND SRWINIT’) This user exit sets up information for use by flexfields, user profiles, the concurrent manager, and other Oracle Applications features. You must include this step if you use anyOracle Application Object Library features in your report (such as concurrent processing). Step 2 Define your After Report Trigger, 8/23/2011 · SRW.User_Exit(‘FND FLEXSQL CODE=GL # NUM=:P_Struct_Num Appl_short_Name=SQLGL Output=:P_Flex_Data Mode = Select Display =All’) compile and close. 3. In After Report Trigger SRW.USER _EXIT(‘ FND SRWEXIT’) compile and close. 4. Go to Data Model in Report Builder selet Last_update_date,&P_Flex_Data C_Flexdata from gl _ code.
Step 4 Call FND FLEXSQL from your Before Report Trigger to populate P_FLEXDATA. SRW.REFERENCE(:P_STRUCT_NUM) SRW.USER_EXIT(‘FND FLEXSQL CODE=GL # NUM=:P_STRUCT_NUM APPL_SHORT_NAME=SQLGL OUTPUT=:P_FLEXDATA MODE=SELECT DISPLAY=ALL’) Step 5 Call FND FLEXSQL from your Before Report.
CODE Specify the flexfield code for this report (for example, GL #). You call FLEXSQL multiple times to set up SQL fragments when reporting on multiple flexfields in one report. APPL_SHORT_NAME Specify the short name of the application that owns this flexfield (for example, SQLGL). OUTPUT, 6/20/2016 · SRW.USER _EXIT(‘ FND SRWINIT’) FND SRWEXIT: FND SRWEXIT ensures that all the memory allocated for Oracle AOL user exits has been freed up properly. [After Report trigger]. You always call FND SRWEXIT from the After Report Trigger. SRW.USER _EXIT(‘ FND SRWEXIT’) Note:- Mandatory Parameter with SRWINIT AND SRWEXIT is.
SRW.REFERENCE(:P_STRUCT_NUM) SRW.USER_EXIT(‘FND FLEXSQL CODE=GL # NUM=:P_STRUCT_NUM APPL_SHORT_NAME=SQLGL OUTPUT=:P_COMPANY MODE=SELECT DISPLAY= GL _BALANCING’) The second call populates the value of lexical P_WHERE with the restriction you want to apply at run time. You want this parameter to.
6/6/2012 · srw.user_exit(‘fnd flexsql } code=gl # }– this we shud write in before report trigger num=:p_coa_id }– this is for displaying structure and retrive the data from database appl_short_name=sqlgl …
9/13/2012 · srw.user_exit(‘fnd flexsql } code=gl # }– this we shud write in before report trigger num=:p_coa_id }– this is for displaying structure and retrive the data from database appl_short_name=sqlgl …
8/14/2012 · Make sure that the GL _ CODE _COMBINATIONS table is in your query and has an alias After the last condition in your query add this &WHERE_FLEX … SRW.User _Exit(‘ FND SRWINIT’) srw.user_exit(‘FND FLEXSQL CODE=GL # NUM=:STRUCT_NUM APPL_SHORT_NAME=SQLGL OUTPUT=:WHERE_FLEX TABLEALIAS=glc –glc in the above line is the GL _ CODE …
