61. What are the two mandatory parameters required for running a PL/SQL Procedure based concurrent program?
Errbuf, Retcode
62. How can you ensure that only one instance of a concurrent program runs?
Check the „Run Alone? check box in Concurrent program registration window.
63. Within a PL/SQL procedure which API is to be used to extract a profile value?
FND_PROFILE.GET
64. How do you set the operating unit context in a report?
Begin
Dbms_application_info.set-client-info(<Organization_Id>);
End;
65. Can you submit a concurrent request from the operating system directly?
- Write a Shellscript.
- Login to database
- Run the function FND_REQUEST.Submit()
Check the?Enable Trace? check box in concurrent program registration window.
67. How do you “write” to the concurrent request Log and Output file?
FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, <Text>);
68. What is the difference between Operating Unit and Inventory Organization?
Operating Unit :- An Organization that uses Oracle Cash management, Order management and Shipping Execution, Oracle Payables, Oracle Purchasing, and Oracle Receivables. It may be a sales Office, a division, or a dept. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications. Each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.
An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products. Examples, include (but are not limited to) manufacturing plants, warehouses, distribution centers, and sales offices. The following applications secure information by inventory organization: Oracle inventory, Bills of Material, Engineering, and Work in Process, Master Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of these applications, you must choose an organization that has been classified as an inventory organization.
69. What is Set of Books?
A financial reporting entity that uses a particular chart of accounts, functional currency, And accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.
70. What is Item Validation Organization?
The organization that contains your master list of items. You define it by setting the OM: Item Validation Organization parameter. You must define all items and bills in your Item Validation Organization, but you also need to maintain your items and bills in separate organizations if you want to ship them from other warehouses.
71. Mention the table or views where Inventory Org, Items, Set of Books, GL Code Combinations, Operating Unit, Location, Customers, Vendors, and Invoices are stored in Apps.
Inventory Org: - MTL_PARAMETERS/ORG_ORGANIZATION_DEFINITIONS
Items: - MTL_SYSTEM_ITEMS_B
Set of Books: - GL_SETS_OF_BOOKS
GL Code Combinations: - GL_CODE_COMBINATIONS
Operating Unit: - HR_ALL_OPERATING_UNITS
Location: - MTL_ITEM_LOCATIONS
Customers: - RA_CUSTOMERS
Vendors: - PO_VENDOR_CONTACTS
Invoices: - AP_INVOICES_ALL
72. What is the profile to be read to find out what Inventory Organization and Operating Unit are you on?
(mfg_organization_id is the Inventory Org)
73)What is Inventory Master Organization?
Items are defined in an Inventory Master Organization.
74)What is the difference between key flexfield and Descriptive flexfield?
75)Which procedure should be called to enable a DFF in a form?
FND_DESCR_FLEX.DEFIN
(
BLOCK => 'BLOCK_NAME',
FIELD => 'FORM_FIELD_NAME',
APPL_SHORT_NAME => 'APP_NAME',
DESC_FLEX_NAME => 'DFF_NAME'
);
