Page 1 of 1

Custom report Initialization settings

Posted: Mon Apr 27, 2020 5:01 am
by admin
1. BEFORE REPORT trigger should have SRW.USER_EXIT('FND SRWINIT');

function BeforeReport return boolean is
begin
SRW.USER_EXIT('FND SRWINIT');
return (TRUE);
end;

2. AFTER REPORT trigger should have SRW.USER_EXIT('FND SRWEXIT');

function AfterReport return boolean is
begin
SRW.USER_EXIT('FND SRWEXIT');
return (TRUE);
end;

3. Create one user parameter P_CONC_REQUEST_ID

4. This is required for MOA and now you can use environment variables and profile values

AND fu.USER_NAME = fnd_global.user_name

5. Register and upload the report in R12 instance and submit to view the output.