 Related Questions Latest Answer : Order EnteredOrder BookedDispatch EligibleDispatchedPick Release EligiblePick ReleasedShip ConfirmInvoicedPosted in GL ... 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 ... 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 Latest Answer : There are 8 templates in Oracle Reports.1.Tabular 2.Group Above 3.Group Left 4.Mailing Label 5.Matrix 6.Matrix with Group 7.Form Like 8.Form LetterCheers!!!!!!! ... Read Answers (2) | Asked by : RAVI SANKAR
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0