INTERVIEW QUESTIONS ORACLE APPS AOL DETAILS

Question: What are the interface tables used for ar invoices, customers, receipts for conversion process

Answer: Following are the Validation for Autoinvoice:



· AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)

· Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).

· Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).

· Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).

· Primary Sales Representative Validation: Sales representative number to be hardcode to “-3” for “No Sales Credit.”

· Term Name : Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)

· Validate Sales Credit Type : Sales Credit to hardcode to “Quota Sales Credit”

· Inventory Item Validation: Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).

· Unit of Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table

· Invoice Tax Code Validation : Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.

· Invoice GL Date Validation : Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.

Following are the Validation for Autoinvoice:



· AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)

· Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).

· Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).

· Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).

· Primary Sales Representative Validation: Sales representative number to be hardcode to “-3” for “No Sales Credit.”

· Term Name : Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)

· Validate Sales Credit Type : Sales Credit to hardcode to “Quota Sales Credit”

· Inventory Item Validation: Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).

· Unit of Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table

· Invoice Tax Code Validation : Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.

· Invoice GL Date Validation : Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.


Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question