Interested to Buy Any Domain ? << Click Here >> for more details...
What are User Exits and what are different types of User
Exits in Oracle Apps ?
- 2 Answers
- 10387 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anil
this is one of the program.it will transfer report control from report execution to another 3rd generation language get the information and complete the remaining process
there r 5 user exits
1.fnd srwinit
2.fnd srwexit
3.fnd flexsql
4.fnd flexidval
5.fnd formatcurrency
| Is This Answer Correct ? | 3 Yes | 0 No |
A user exit is a 3GL program where it can be linked to
the report builder executable
There are 3 types of user interfaces
1> ORACLE user interfaces
2> OCI (Oracle Caller Interface)
3> None-Oracle user exit
We can integrate Oracle reports with Oracle Application
Object Library, and run them as concurrent programs from
your forms or through standard request submission.
These are the user exits available in Oracle Reports that
makes AOL integration.
SRW.USER_EXIT(’FND SRWINIT’);
Define it in Before Report Trigger
This user exit sets up information for use by flexfields,
user profiles, the concurrent manager, and other Oracle
Applications features.
SRW.USER_EXIT(’FND SRWEXIT’);
Define it in After Report Trigger
This user exit frees all the memory allocation done in other
Oracle Applications user exits.
SRW.USER_EXIT(’FND FLEXSQL......');
Call FND FLEXSQL in Before Report Trigger to get the
Flexfield values
SRW.USER_EXIT(’FND FLEXIDVAL......');
Call FND FLEXIDVAL in Format Triggers to populate Flexfield
values
SRW.USER_EXIT(’FND FORMAT_CURRENCY......');
Call this User Exit in any format trigger to format the
Amount fields
| Is This Answer Correct ? | 3 Yes | 0 No |
WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?
What are the types of visual attribute settings?
What is a matrix report and how many minimum groups are required to prepare the same?
Can you truncate a table in a procedure in Oracle Forms?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
What are the built-ins used for processing rows?
Name the different triggers associated with oracle forms having a master-detail relationship.
What are Most Common types of Complex master-detail relationships?
List the system variables related in Block and Field?
What are the triggers associated with a check box?
What are the menu items that oracle forms 4.0 supports?
State the order in which these triggers are executed ?
Oracle General 
