Some Standard Oracle Apps Report Customizations

what are the standards for report developments in oracle apps?

------------------------------------------------------------------------------

Oracle Applications Standards for New Report Developments...

For developing a Report in Oracle Applications we should follow three standards.

--------------------------------------------------------------------------------

1. Creation of Bind Variable - P_CONC_REQUEST_ID: We must create a Bind Variable called “P_CONC_REQUEST_ID” (We can’t change this name. It is standard name.). If we run Conc. Prgm. from SRS window, it will give a Request ID. It will get store in ‘P_CONC_REQUEST_ID” automatically. This Bind Variable is useful, when we call another Conc. Prgm. with in a Conc. Prgm.

2. FND SRWINIT in Before Report Trigger:

We call the USER_EXIT (‘FND SRWINIT’) form Before Report Trigger. Syntax is

SRW.USER_EXXIT(‘FND SRWINIT’):

This USER_EXIT is initializing the user profiles in the report trigger i.e., before getting the date from the Database.

Note:

While executing the Conc. Prgm. the system allocate memory for the program which contains all details of user. In above syntax,

SRW.USER_EXIT refers to D2K and purpose of this is, when we want to transfer the control from execution of report to other 3rd generation language and again transfer the control to report execution.

FND SRWINIT refers to Oracle Applications. Purpose of this is to get the “User Profile”.

3. FND SRWEXIT in After Report Trigger:

We call the USER_EXIT (‘FND SRWEXIT’) form After Report Trigger. Syntax is

SRW.USER_EXXIT (‘FND SRWEXIT’):

This USER_EXIT is frees the memory which is occupied by user profiles.