Steps for AR Invoice Interface are: 1.Put the data into your staging tables.
2.Calls your package to validate the data and
load into AR Interface tables (RA_INTERFACE_LINES_ALL &
3.Then submits a concurrent request for
If any errors occur it can be found in ra_interface_errors_all
table. The concurrent program has 2 stages. First the Master program fires
which intern kicks of the Import Program. Once this is completed data is
inserted into the following tables. 1) ra_customer_trx_all (Invoice Header Info)
2) ra_customer_trx_lines_all (Invoice Line Level Info)
3) ra_cust_trx_line_gl_dist_all (Accounting Info. One record for
each Account Type is inserted into this… ex. Receivable Revenue Tax Freight
4) ar_payment_schedules_all (All Payment related info)
Validation are generally done on the below columns.
·Accounting Flexfields segments
1- AR Transaction Type Validation: Check if the Transaction type
provided in data file is defined in AR transaction types
2- Transaction Batch Source Validation: Check if the source
provided in data file is defined in AR transaction Batch source
3- Invoice Currency Validation: Check if the currency provided in
data file is defined in AR Currency (FND_CURRENCIES).
4- 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).
5- Primary Sales Representative Validation: Sales representative
number to be hardcode to “-3” for “No Sales Credit.”
6- Term Name: Check if the Term name provided in the data file is
defined in Payment terms (RA_TERMS)
7- Inventory Item Validation: Check if the Item provided in data
file is defined in Inventory Items (MTL_SYSTEM_ITEMS).
8- Unit of Measurement validation: Check if the UOM provided is
defined in MTL_UNITS_OF_MEASURE Table
9- Invoice Tax Code Validation: Check if the Tax Code provided in
data file is defined in AR_VAT_TAX_ALL_B Table.
10- Invoice GL Date Validation: Check if the GL Data of provided
invoices is in open period.
You need to add the below columns and need to do validations if
your application supports MOAC.