Purpose of USER_EXIT?

[Rammi]

Hi Folks,

GoodDay, Itz Ram. What is USER_EXIT & purpose of USER_EXIT. Why we should use USER_EXIT while preparing(customizing) Apps Reports? Please be clear..

Regards,
Ram..

[prasadt]

It is one of the Oracle Reports 6i Built In program which will be used to stop the
report execution and pass the control into some other 3GL and retrieves the data
then complete the remaining report execution Process.

We have 5 User Exits in Oracle Applications:
FND SRWINIT
FND SRWEXIT
FND FLEXSQL
FND FLEXIDVAL
FND FORMATCURRENCY

FND SRWINIT : This User Exit we will initialize user Profile values we will call this
user exit from Before Report Trigger.

FND SRWEXIT: This User Exit will frees the Memory which is Occupied by the User Profile
values in the server. we will call this from After Report Trigger.


We have Five types of Report Triggers :

Before Parameter Form
After Parameter Form
Before Report Trigger
Between Pages
After Report Trigger

We are using Before Report trigger before data is retrieving from data base system
will capture the user profiles data and as per that data will be retrieved from
database.
Once Output is generated we do not reuire the Information in the system for that
we are using after Report Trigger call the another User Exit.


P_CONC_REQUEST_ID : This is One of the mandatory parameter we have to define for every
concurrent Program.when we submit C.P from SRS window which will generate the
REQUEST_ID that request ID will be passed into this variable.