Thursday, May 26, 2011
User exits in Oracle Reports - Quick Overview
In General, User Exits are 3GL programs used to transfer the control from the report builder to Oracle Applications or any and where it will perform desired actions and return to the report builder.
There are five types of user exits and are listed below.
1. FND SRWINIT
2. FND SRWEXIT
3. FND FORMAT_CURRENCY
4. FND FLEXSQL
5. FND FLEXIDVAL
FND SRWINIT: Used to write in before report trigger. It is used to fetch the concurrent request information and also used to set the profile options.
FND SRWEXIT: We will write this in after report trigger. Used to free the memory whichhas been allocated by the other user exits
FND FORMAT_CURRENCY: This is used to convert amounts or currency from one currency to other currency values and also used to display currency amounts in formats.
SRW.USER_EXIT
('FND FORMAT_CURRENCY',
Code = 'currency_code',
Display_width= 'DISPLAY FEILD WIDTH',
Amount = ':SOURCE_COLUMN_NAME',
Display = ':DISPLAY_COLUMN_NAME'
);
FND FLEXSQL: This is used to get the data from flex fields. We will use in formula columns.
FND FLEXIDVAL: This is used to get the data from flex fields. We will use them in formula columns.
Note:
1. We use the User Exits in the Report triggers like before report, after report, before parameter form, after parameter form.
2. We have to create a mandatory parameter called P_CONC_REQUEST_ID when we work with FND SRWINIT, FND SRWEXIT.
3. The user exits are case sensitive we have to write them in capital letters only otherwise they will raise an error.
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “User exits in Oracle Reports - Quick Overview”
Post a Comment