User exits in Reports?

User Exits are 3GL programs used to transfer the control from the report builder to Oracle Applications or any and it will perform some actions and return to the report builder. There are five types of user exits:

Ø  FND SRWINIT

Ø  FND SRWEXIT

Ø  FND FORMAT_CURRENCY

Ø  FND FLEXSQL

Ø  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 which has 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.

EX: SRW.USER_EXIT(‘FND FORMAT_CURRENCY’,

Code = ‘currency_code’,

Display_width=’15’,

Amount = ‘:cf_feb’,

Display = ‘:cd_feb’);

Return (:cd_feb);

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.