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.