AutoInvoice Program Overview in Oracle Applications – Receivables

AutoInvoice Overview

AutoInvoice is a powerful, flexible tool you can use to import and validate transaction data from other financial systems and create invoices, debit memos, credit memos, and on-account credits in Oracle Public Sector Receivables. You use a custom feeder program to transfers transaction data from an external system into the AutoInvoice interface tables. AutoInvoice then selects data from the interface tables and creates transaction in Receivables. Receivables rejects transactions with invalid information to ensure the integrity of your data.

How the Order Information gets stored in RA_INTERFACE_LINES Table?

Column	Vales Stored in
INTERFACE_LINE_ATTRIBUTE1	Order Number
INTERFACE_LINE_ATTRIBUTE2	Order Type
INTERFACE_LINE_ATTRIBUTE3	Delivery Name
INTERFACE_LINE_ATTRIBUTE4	Way Bill
INTERFACE_LINE_ATTRIBUTE5	Count
INTERFACE_LINE_ATTRIBUTE6	Line ID
INTERFACE_LINE_ATTRIBUTE7	Picking Line Id
INTERFACE_LINE_ATTRIBUTE8	Bill Of Lading
INTERFACE_LINE_ATTRIBUTE9	Customer Item Part
INTERFACE_LINE_ATTRIBUTE10	Warehouse Id
INTERFACE_LINE_ATTRIBUTE11	Price Adjustment Id