Custom report Initialization settings

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Custom report Initialization settings

Post 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.
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest