Oracle Apps Interview Questions-11

151). What is the use of Auto lock Box?
Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.

152). Auto Lockbox is a three-step process, what are those?

• Import
• Validation
• PostQuickCash

153). What is the order in which Autolock box searches for the types of the matching number?

• Transaction Number
• Sales Order Number
• Purchase Order Number
• Consolidated Billing Invoice Number
• Other, user-defined number.

154. What is application short name for General Ledger you specify in FND FLEXSQL user exit?SQLGL

155) . What are validations to be done in Journal Import interface?
Batch level: Set of Books, Period Name, and Batch Name
Journal Level: Set of books, Period name, Source name, Journal entry name, Currency code, Category name, Actual flag, Encumbrance type ID, User conversion type, Accounting date, Budget version ID

156) What subclass in forms6i ?
Specifies module, storage & name information about the source object and source module for a referenced objects.

157) What is the clause in SQL * Loader to program to override data into table?
REPLACE

158). How do you set profile in oracle applications In Application Developer responsibility?
Open „Profile‟ Function

159). What is the syntax for loading data through SQL * Loader from multiple files simultaneously?
Sqlldr scott/tiger@orcl control = ctlfile
parfile -- parameter file: name of file that contains parameter specifications
parallel -- do parallel load (Default FALSE)

160) What is the table name for items in Oracle Inventory?
MTL_SYSTEM_ITEMS, MTL_CATEGORIES

161). Tell me names of important production tables & their purpose AP, AR, GL, PO?
AP: AP_INVOICES_ALL, AP_INVOICE_LINES_ALL To store invoices
AR: RA_SHIPMENT_HEADERS/ _LINES, RA_CUSTOMERS, RA_CONTACTS
PO: PO_VENDORS, PO_VENDOR_SITES - For storing vendor data.

162). Name the interface tables used for the LockBox Interface?
Interface table : AR_PAYMENTS_INTERFACE_ALL
Lockbox transfers the receipts that pass validation to the Receivables interim tables AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL
When you run Post QuickCash, the receipt data is transferred from the QuickCash tables to the following Receipt tables:

• AR_CASH_RECEIPTS_ALL
• AR_RECEIVABLES_APPLICATIONS_ALL
• AR_CASH_RECEIPT_HISTORY_ALL

163) Name the interface tables used for the Auto Invoice Interface?
Auto Invoice transfers transaction data from the interface tables

• RA_INTERFACE_LINES_ALL,
• RA_INTERFACE_SALESCREDITS_ALL, and
• RA_INTERFACE_DISTRIBUTIONS_ALL

into the following Receivables tables:

• RA_BATCHES_ALL
• RA_CUSTOMER_TRX _ALL
• RA_CUSTOMER_TRX_LINES _ALL
• RA_CUST_TRX_LINE_GL_DIST_ALL
• RA_CUST_TRX_LINE_SALESREPS_ALL
• AR_PAYMENT_SCHEDULES_ALL
• AR_RECEIVABLE_APPLICATIONS_ALL 49
• AR_ADJUSTMENTS_ALL

164). Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i)?
There are 8 types of Values Sets.
a. None (Non Validate at all) (Validation is Minimal)
b. Independent (Input must exist on previous defined list of values)
c. Dependent (Input is checked against a subset of values based on prior Value)
d. Table (Input is checked against a subset of values in an application table)
e. Special (advanced) (Value set uses a flexfield itself)
f. Pair (advanced) (Two Flexfields together specify a range of valid values)
g. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)
h. Translatable Dependent. (Input is checked against a subset of values based on a prior value; translated value can be used)

(Note:- When you first define your flexfields, you choose how many segments
You want to use and what order you want them to appear. You also
Choose how you want to validate each of your segments. The decisions
You make affect how you define your value sets and your values.)

165) How to run a concurrent program. What all concurrent programs u have
created.?
Definition :- A concurrent program is an instance of an execution file, along with
parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.
Oracle Tool Concurrent Program * A concurrent program written in
Oracle Reports, PL/SQL package procedures,
SQL*Loader, SQL*Plus, Host Scripting.

How to Run : * Write a execution file and place in correct directory.
Establish executables in Oracle apps specify execution file and method.
Define Concurrent Program (Program, Parameters and Incompatibilities)
Call your Program (- Thu application form, from other concurrent program.
OR through standard request submission, you must check the „USE in SRS check box‟ and register your program parameters when you define your concurrent program. Add your program into the request security group for your custom application.)
I have created reports through concurrent program, load(sql*loader/pl-sql pkg-proc) the file through concurrent program. 

<<<Previous    Continue>>>