what is user exit and wat program do we write in user exit?
Answers were Sorted based on User's Feedback
Answer / manohar
User Exits are used to pass control from report builder to
outside program.
Basically if we want to create any flex field reports.
we need to get the structure and code combination and
description of flexfileds at that time we use userexits.
srw.flex_sql,flexid_val,srw.init etc..
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / santhi
User exit is a facility in oracle reports. It is used to move control from reports to 3GL and get some data, after that it will move control back to oracle reports.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ram chaturvedi
User exit is a program to pass control from Report Builder
to a program you have written, which performs some
function, and then returns controlto Report Builder.
We can write UE in before report trigger to populate
the value.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / tuhin
User exit is a oracle inbuilt package, for multi org environments it is automatically set the user profile option.
SRW.USER_EXIT('FND SRWINIT') is mainly written in Before Report in 11i and After Parameter Form for R12.
SRW.USER_EXIT('FND SRWEXIT') is written in After Report. It is freed up all the memory allocation while running the particular report.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can We Create a Synonym On Trigger?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
in ap_terms table what data will be stored
What is Place holder Columns?
what are the sql attributes?
What repots or concurrent program run to transfer data from Inventory to GL.
How many parameters we can pass through pl/sql program in Oracle apps
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
When loading data from staging table to interface table , how to reload the invalid record once again ?
what is instead of trigger in where u will use?
What are file in oracle.
in ap_terms table what data will be stored