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 do u place it in required folder
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
what is difference between group above and group left report
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
How can we expand Parameter Form Canvas on Reports 6i?
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
Explain how one can iterate through items and records in a specified block?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
How to create Drill down report?
if some data is not transfered where it will get stored
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 do you understand by lov?
Is it possible to have multiple layouts in a report?
a text item is there what r the different types of triggers associated with it
What is the difference between flex mode and confined mode?