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
- 10355 Views
- I also Faced
- E-Mail Answers
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
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Explain master-detail relationship with some examples.
what is tripstop report?
what are bind variables?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
In what sequence do triggers get fired by oracle forms?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
what are the oracle forms services components include?
a text item is there what r the different types of triggers associated with it
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 ?
What is the difference between bind and lexical parameter?
