User Exit

Program which will transfer the control from Report builder to some other 3GL.

It is one of the Oracle  Reports 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.

Types of user Exists? 5 .

1. FND SRWINIT 
2. FND SRWEXIT 
3. FND FORMATCURRENCY  
4. FND FLEXSQL 
5. FND FLWXIDVAL

FND_SRWINIT: - This is a User Exit which sets your profile option values and allows Oracle AOL user exits to detect that they have been called by oracle repots.

Can be used in BEFORE-REPORT Trigger.

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

FND_SRWEXIT: This user exit ensures that all the memory allocated for AOL user exits have been freed up properly. Can be used in AFTER- REPORT Trigger .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.

  

FND FORMAT_CURRENCY: To format the currency amount dynamically Depending upon the precision of the actual currency value, standard precision, users profile values and location (country) of the site.

FND FLEXSQL :This user exits allows you to use Flex fields in Reports

FND FLEXIDVAL:  This user exits allows you to use Flex fields in Reports

Program which will transfer the control from Report builder to some other 3GL.