R12 Oracle Financials – Accounts Receivables

iWare Logic > Blog  > R12 Oracle Financials – Accounts Receivables

R12 Oracle Financials – Accounts Receivables


  • Finance Executives
  • Oracle Finance Consultant
  • Oracle – End Users


  • This article will help you to understand what are Auto-Invoices
  • Flow of Auto-Invoice in Oracle
  • At which level Auto-Invoice comes into picture
  • What is Auto-Invoice process
  • List of Errors may be faced during Auto-Invoice process

What is mean by Auto-Invoices?

On daily basis, there are multiple sales invoices to be created manually, when we need to create multiple invoices in short time then it becomes difficulty. However Oracle EBS is providing a very strong mechanism to import the receivables transactions (Sales invoice) within oracle (OM) and from external system.

Oracle has given functionality to convert the sales orders into sales invoices as well as import ready transaction from non oracle system. Using the details in Sales Order Oracle system uses the interface tables and concurrent program to import the Invoices.
Auto invoice is the interface between Order management and Account Receivables. Auto invoice picks imported data from AR interface tables, validate and create transactions in AR.

Auto-Invoice Flow in Oracle

order to  cash cycle

Order to Cash Cycle (OM to AR)

  • Sales Order can be entered from number of different sources, one can Enter Sales Order manually or import from CRM, EDI or other  systems.
  • Credit management also performs a credit check on the customer, According to your credit management set-up.

After credit check depending upon management decision, you Can Book the Sales Order:

  • Once the order is booked , then we will check the ATP, place a demand and reserve on-hand Inventory and we will do the Pick release

Once the order is picked from the stores and released to staging area, then we need to Ship these inventories to Customer’s Ship to Location through Carrier

Trigger point where Auto-Invoice process starts:

What is Auto-Invoice Process?

Image: What is Auto-Invoice Process?

Transaction data originates from Oracle applications and legacy systems. When the data is brought into the Interface Tables, errors are tracked into the Interface Exceptions Table where they can be corrected. Once the lines are corrected, Auto-Invoices created from the corrected lines. Corrected data is sent to Receivables via the Auto-Invoice program; this includes corrected data for debit memos, credit memos and Invoices.

Interface Table (Auto-Invoice)
The RA_INTERFACE_LINES interface table stores invoice information. You use SQL*Loader to load invoice information into the interface table for each invoice that you create. When you initiate importing invoices, the Auto-Invoice open interface validates global attribute columns in the RA_INTERFACE_LINES table before creating invoice and invoice lines in Oracle Receivables.

If you want to see the table details the check the link below:

Auto-Invoice Import Process:

Once the data is inserted into the Interface table, we are ready to submit the Auto-Invoice Import Process:
Responsibility: Receivables Manager
Navigation: Interfaces > Auto-Invoice

  1. Submit “AutoInvoice Master Program” program.
  2. Once the request is submitted wait for request to be completed successfully.
  3. Then go to Transactions> Transactions.
  4. Click on to find the customer.
  5. Enter the customer & sales Order number & click on Find Button.
  6. You can view your transaction online.
  7. There is a button circle in Red which is BPA (Bill Presentment Architecture), clicking on which you can see your sales invoice online.

Submit “AutoInvoice Master Program” program:

Check concurrent Request Status:

Transactions > Transactions

Enter the customer and sales Order number and click on Find Button:

You can view your transaction online:

List of Errors may be faced during Auto-Invoice process:

Responsibility: Receivables Manager Navigation: Control > Auto-Invoice > Interface Line

Below mentioned are the few examples of errors in Interface lines for AutoInvoice:

  • Invalid Warehouse ID (WAREHOUSE_ID)
  • Unable to derive a gl date for your transaction. Please ensure that your transaction is in a gl period which you have defined
  • The CUSTOMER_BANK_ACCOUNT_ID column is obsolete. You are not allowed to pass a value to this column.
  • The supplied receipt method must be defined and active for the bill-to customer or site.
  • When the receipt method is of type Automatic, you must either supply a valid bank account or ensure that a primary bank account for the currency code of the transaction has been set up for the Bill To customer.
  • Please supply both an invoicing rule and an accounting rule for this invoice.
  • Please define all periods in which revenue is to be recognized or credited.
  • Invalid sales credit type name (SALES_CREDIT_TYPE_NAME)

Note: The best practice to correct the error is to correct it in the source system & resubmit the AutoInvoice.

– Nilkanth Gheware