What are User Exits and what are different types of User
Exits in Oracle Apps ?
Answer Posted / mark_jella
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 |
Post New Answer View All Answers
What is a user exit program in oracle reports?
Explain master-detail relationship with some examples.
How can we generate report output in excel format?
from where do u receive the information to develop report
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
what are bind variables?
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
how do u compile a form i.e .fmb file in Unix or in dos
What is an oracle report? List its various types.
how to send file attachment from oracle forms
What is a matrix report and how many minimum groups are required to prepare the same?
How to create Drill down report?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What is the difference between flex mode and confined mode?