Loading

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.

0 Responses to “User exits in Oracle Reports - Quick Overview”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.