Custom report Initialization settings
Posted: Mon Apr 27, 2020 5:01 am
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.
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.