USER EXITS IN Oracle Apps Reports 

USER EXITS

User Exits are C and Pro C programs which is used to initialize and capture profile values and flex fields.

User Exits are C and Pro C compilers which are used to capture values of different environment variables.

Type of User Exits

SRW.USER_EXIT (‘FND SRWINIT’);

SRW.USER_EXIT (‘FND SRWEXIT’);

SRW.USER_EXIT (‘FND FLEXSQL’);

SRW.USER_EXIT (‘FND FLEXVALID’);

SRW.USER_EXIT (‘FND FORMAT_CURRENCY’);

Description

1)  SRW.USER_EXIT (‘FND SRWINIT’);

                Is used to initialize profile values.

2)  SRW.USER_EXIT (‘FND SRWEXIT’);

      Is used to free the memory allocated.

3)       SRW.USER_EXIT (‘FND FLEXSQL’);

                Is used to capture description of code combinations.

4)  SRW.USER_EXIT (‘FND FLEXVALID’);

      Is used to capture code combination ID.

5)  SRW.USER_EXIT (‘FND FORMAT_CURRENCY’);

      Is used to format currency.

Where the five User Exits are used

In Before Report trigger	SRW.USER_EXIT (‘FND SRWINIT’); SRW.USER_EXIT (‘FND FLEXSQL’); SRW.USER_EXIT (‘FND FLEXVALID’); SRW.USER_EXIT (‘FND FORMAT_CURRENCY’);
In After Report trigger	SRW.USER_EXIT (‘FND SRWEXIT’);