Oracle Apps Interview Questions-11

Oracle Apps Interview Questions,

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?

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?

161). Tell me names of important production tables & their purpose AP, AR, GL, PO?
PO: PO_VENDORS, PO_VENDOR_SITES - For storing vendor data.

162). Name the interface tables used for the LockBox Interface?
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:

163) Name the interface tables used for the Auto Invoice Interface?
Auto Invoice transfers transaction data from the interface tables
into the following Receivables tables:
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

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.