 Related Questions Latest Answer : Registering Oracle Reports: Step 1: Register a concurrent program executable Navigate to the Define Executable form (AOL Reference manual pg 9-84) This determines the type of program being run,ie an Oracle Report. ... Latest Answer : FND_CURRENCY is basic foundation class used to format currency. Ex. 1234556 By using above we can print it as 12,34,556 ... The steps are as follows :Design your report.Generate the executable file of the report.Move the executable as well as source file to the appropriate product’s folder.Register the report as concurrent Latest Answer : STEP- ONE: Register the application. STEP-TWO: Put Report in appropriate server directory. STEP-THREE: Define Executables. (NavigatoràConcurrentàProgram ... The cursor are used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all it’s queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with Latest Answer : If you have not used REF cursor, then when you need to open cursors multiple time, it will throw an error. Because in a procedure there is a limitation availe for maximum number of cursors to be open at any point of time. ... An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization. Latest Answer : Descriptive FlexFields are the additional fields provided by Oracle Apps to store any Additional Information which cannot be captured elsewhere in the form. There are maximum of 15 Attributes available in 11i whereas 30 Attributes that are available in ... What are Autonomous transactions ? Give a scenario where you have used Autonomous transaction in your reports ? An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or There are two ways to use Flexfields in report. One way is to use the views (table name + ‘_KFV’ or ’_DFV’) created by apps, and use the concatenated_segments column which holds Latest Answer : Can use fnd.flexsql for retreiving data from the flex-fields in the report using lexical reference. ... Key Flexfield: #unique identifier, storing key information# Used for entering and displaying key information.For example Oracle General uses a key Flexfield called Accounting Flexfield to uniquely Latest Answer : Key Flex Field:KFF is a Mandatory field which is already driving the functionality and it is the field where atleast first segment is made mandatory.KFF willbe filled in segmentsKFF Is mandatoryKFF Drives functionalityNavigation is Inventory(Navigator)->Setup->FlexField-Key->Segmentsthen ... API - Application Program Interface is a PL/SQL call made to the application to create business transactions or events. This is an alternative to using the interface tables in applications to insert and Latest Answer : In Addition to Following :In ALL_OBJECTS Query for OBJECT_TYPE = 'PACKAGE'%PUB Are Public API's, in Short wrapper Over %PKG APIs. ... Read Answers (1) | Asked by : sramchand Latest Answer : _all tables would be typically for transactions. it stores multi org information.
Eg: oe_order_headers_all ...stores information of sales order headers information of different OU's.
But oe_order_headers stores order header info of a particular ... Read Answers (5) | Asked by : Rajesh
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
