Answer Posted / preeti
Types of user exits
FND SRWINIT sets your profile option values and allows
Oracle AOL user exits to detect that they have been called
by a Oracle Reports program.[Before Report trigger,
P_CONC_REQUEST_ID lexical parameter]
FND SRWEXIT ensures that all the memory allocated for
Oracle AOL user exits has been freed up properly. [After
Report trigger]
FND FORMAT_CURRENCY is used for MULTIPLE CURRNECY REPORTING
(MRC) [formula Column, P_MIN_PRECISION lexical parameter]
FND FLEXSQL this API is used for get
ELECT/WHERE/HAVING/ORDER BY/GROUP BY from flex field
tables.
FND FLEXIDVAL this API is used for get descriptions from
flexfields, gets input from FND FLEXSQL.
Call this user exit to populate fields for display. You
pass the key flexfields data retrieved by the query into
this exit from the formula column. With this exit you
display values,descriptions and prompts by passing
appropriate token (VALUE/DESCRIPTION/APROMPT/LPROMPT).
it will take inputs from columns of query , the columns are
defined by FND FLEXSQL.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can we expand Parameter Form Canvas on Reports 6i?
what is oracle forms?
What is the difference between bind and lexical parameter?
what exactly u write in when_new_form_instance
Name the different triggers associated with oracle forms having a master-detail relationship.
What is an oracle report?
What do you understand by lov?
What is responsibility and how u attach How to create user and how u attach with responsibility.
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What is a canvas in oracle forms?
what is difference between group above and group left report
What is a matrix report and how many minimum groups are required to prepare the same?
if u want to delete all these detail block etc what will happen in form
Explain the different levels at which oracle form services interact.