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
what is oracle forms?
What do you understand by oracle forms?
What is a canvas in oracle forms?
How to create Drill down report?
what exactly u write in when_new_form_instance
List out the oracle forms configuration files?
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
how report can be generated if we have the database designed in oracle 10g?
why the Ctl file u put only in bin folder why not in other folder
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Explain how can you use the same lov for 2 columns?
Can we invoke one form from another in a multi-forms application?
What is a matrix report and how many minimum groups are required to prepare the same?
what are the oracle forms services components include?
What is an oracle report? List its various types.
