To Initialize Apps in Oracle Report: BELOW 3 steps mandatory(3.1 to 3.3) and use the secured tables in query.
3.1. Before report trigger
srw.USER_EXIT ('FND SRWINIT');
fnd_global.apps_initialize(FND_PROFILE.VALUE('USER_ID'),FND_PROFILE.VALUE('RESP_ID'),FND_PROFILE.VALUE('RESP_APPL_ID'));
mo_global.init ('S');
3.2. After Report Trigger
SRW.USER_EXIT('FND SRWEXIT');
3.3 Add user parameter
P_CONC_REQUEST_ID datatype - Number, Width - 200
No comments:
Post a Comment