Saturday, December 21, 2013

Oracle Receivable Interview Questions

--> Name some Flexfields in AR.
Sales Tax Location, Territory

--> Explain the steps involved in Transfer to GL from AR.
Transfer the transactions to GL_Interface Import the Journals Post the Journals

--> What is the dbnumber of a particular cusotmer TCA?
It is a unique number used to identify the Customers.

--> Where can you find the Customer payment terms?
In the table hz_customer_profiles

--> What is the link between OM and AR?
To relate the Order Number (ONT) to the Invoice (AR) we use the LINE TRANSACTION FLEX FIELDS. In RA_CUSTOMER_TRX_ALL, INTERFACE_HEADER_ATTRIBUTE1 to INTERFACE_HEADER_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order (HEADER INFO). In RA_CUSTOMER_TRX_LINES_ALL, INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order.(LINE INFO)

--> What kind of transactions can be created using AutoInvoice?
Invoices, credit memos, debit memos, and on¿account credits can be imported using AutoInvoice.

--> What are the different Transaction types in AR?
Invoice, Credit Memo, Debit Memo,Charge back, commitments
Explain the different steps in implementing Autolockbox.
Import, Validate, Post Quick Cash

--> What are the different Invoice matching types?
2-way matching: 2-way matching verifies that Purchase order and invoice quantities must match within your tolerances 3-way matching: 3-way matching verifies that the receipt and invoice information match with the quantity tolerances 4-way matching: 4-way matching verifies that acceptance documents and invoice information match within the quantity tolerances

--> What are the underlying tables and validations required during AutoInvoice Interface?
Interface tables: RA_INTERFACE_LINES_ALL Base tables: RA_CUSTOMER_TRX_ALL RA_BATCHES RA_CUSTOMER_TRX_LINES_ALL AR_PAYMENT_SCHEDULES_ALL RA_CUSTOMER_TRX_LINE_SALESREPS RA_CUST_TRX_GL_DIST_ALL AR_RECEIVABLES_APPLICATIONS AR_ADJUSTMENTS RA_CUSTOMER_TRX_TYPES_ALL Concurrent Program: Auto invoice master program Validations: check for amount, batch source name, conversion rate, conversion type. Validate orig_system_bill_customer_id, orig_system_bill_address_id, quantity. Validate if the amount includes tax flag.

--> Tell me about TCA?
TCA canbe used to import or modify Customers related data.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect