Thursday, August 8, 2013

Oracle Apps Interview Questions Part - 17

146) What validation must be given on the CUSTOMER_STATUS

A Must equal 'A' for Active or ?I? for Inactive.

147) Name some of the Oracle receivables Interfaces

A a) Auto Invoice
b) Auto Lockbox
c) Customer Interface 47
d) Sales Tax rate Interface
e) Tax Vendor Extension

148) Give some of the Oracle Payables interface

A. a) Credit Card Transaction Interface
b) Invoice Import Interface
c) Payables Open Interface
d) Purchase Order Matching

149). Name some of the oracle general ledger Interface

A a) Budget Upload
b) Importing Journals
c) Loading Daily rates

150). What are the names of the parameters u pass to the Procedure which u register in the apps

A. 1) retcode in varchar2
2) errbuf in varchar2
151). What is the use of Auto lock Box
A 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

A. a) Import
b) Validation
c) PostQuickCash

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

A. 1. Transaction Number
2. Sales Order Number
3. Purchase Order Number
4. Consolidated Billing Invoice Number
5. Other, user-defined number.
154. What is application short name for General Ledger you specify in FND FLEXSQL user exit
A. SQLGL

155) . What are validations to be done in Journal Import interface.

A. 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 48

A 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

A. REPLACE

158). How do you set profile in oracle applications In Application Developer responsibility

A Open „Profile? Function

159). What is the syntax for loading data through SQL   Loader from multiple files simultaneously

A. 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

A MTL_SYSTEM_ITEMS, MTL_CATEGORIES

No comments:

Post a Comment