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 are the new features introduced in oracle form services in 11g release 2?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
What is responsibility and how u attach How to create user and how u attach with responsibility.
What is a matrix report and how many minimum groups are required to prepare the same?
What is an oracle report?
what is a package n what r the packages availbla in report
List out the oracle forms configuration files?
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
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
what is difference between group above and group left report
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
if u want to delete all these detail block etc what will happen in form
what exactly u write in when_new_form_instance
What do we mean by record group in oracle forms?
Why oracle forms required?