Saturday, November 20, 2010

How are the Transactions populated in the RA Interface table

Invoice processing in Order Management is the process by which data from Orders and Returns is interfaced to Oracle Receivables.

1. After shipping the order, the order lines get eligible to get transferred to RA_INTERFACE_LINES_ALL.
2. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. This is also called Receivables interface that mean information moved to accounting area for invoicing details.
3. Invoicing workflow activity transfers shipped item information to Oracle Receivables. At the same time records also goes in the table RA_INTERFACE_SALESCREDITS_ALL which hold details of sales credit for the particular order.
4. Sales order line status is closed and shipping line status is interfaced then RA_INTERFACE table will get populated.
5. Once all the data is in ra_interface_lines_all, Then Auto-invoice program imports data from this table which get affected into this stage are receivables base table. At the same time records goes in ra_customer_trx_all and ra_customer_trx_lines_all.








The Order Management Invoice Interface activity interfaces sales order line details to Oracle Receivables. Order lines with any of the following conditions are not eligible for Invoice interface:
1. Item with Invoiceable attribute set to No or
2. Item with Enabled Invoicing attribute set to No or
3. Included item type or
4. Configure item type or
5. Item inactivated.

For all conditions listed above, the Invoice Interface workflow activity is completed with a status of Not Eligible.

i) Order Hold: Order or return lines will not be interfaced to Oracle Receivables if there is a hold on the line or on the order. When the invoice interface activity encounters an order or return line with a status of On Hold, the Invoice Interface workflow activity will also complete with a status of On Hold. You can perform the manual ‘Progress Order’ concurrent program to continue with the order processing, or the order or return line will automatically be re-evaluated at a 12 hour interval after the hold is released.

ii) Detailed Flow Statuses for Invoice Interface:
These statuses/messages help you understand when the line is not progressed from invoice interface because of a specific reason.

When using the header level invoice interface, the order flow status is set to identify the Header invoice workflow status. For the header level only, the following statuses are set:
- Awaiting Invoice Interface -- On Hold
i) When at least one order line/header is on hold
- Awaiting Invoice Interface -- Incomplete Data
i) When at least one order line is not able to process due to incomplete data
-Invoice Interface – Complete
i) When all the lines are processed.