Data Flow Among Applications

Data Flow Among Applications

Purchasing to Payables

Data is copied out of purchasing tables into Payables tables when invoices are received and matched against purchase order shipments or receipts.

 

Payables to Assets

When invoice information is entered in the Payables module for an item which will become a fixed asset, such as a vehicle or a building, the MassAdditions process can be used to create asset records from information entered on the Payables invoice. The MassAdditions process may use the Account Generator function to determine the appropriate asset accounts.

Order Management to Inventory

When material is shipped, the Inventory Interface process passes shipment information from Oracle Order Management to Oracle Inventory to decrement inventory item quantities and to record cost of goods sold and a decrease in inventory asset value. This process may use the Account Generator function to determine the appropriate cost of goods sold account.

Order Management to Receivables

Once orders have been shipped, the Receivables interface and AutoInvoice processes may be run to generate customer invoice records automatically from Sales order information. The AutoInvoice process may use the AutoAccounting function described above to determine the appropriate sales revenue, freight revenue, tax revenue, Receivables, and account numbers.

Data Flow to General Ledger

Oracle General Ledger is the central repository for accounting information, receiving transactions from other Oracle applications.

 

Purchasing

The only information passed to General Ledger by the purchasing module is accrued receipt information (asset information for material received but not yet delivered, and liability information for material received but not yet billed).

Payables

The Payables module passes expense and liability information from invoices and cash and liability information from payments to the General Ledger.

 

Assets

The Assets module passes information about asset additions, asset adjustments, transfers, retirements, and depreciation to the General Ledger.

Inventory

The Inventory module passes financial information about material receipts, material shipments, cost of goods sold, changes in inventory asset value due to standard cost adjustments, and changes in inventory asset value due to physical inventory adjustments to the General Ledger.

Order Management

The Order Management module does not pass any information directly to the General Ledger. When material is shipped, order management passes information through the inventory interface to the Inventory module to record the shipment, and Oracle Inventory then passes that information on to the General Ledger.

 

Receivables

The Receivables module passes sales revenue and Receivables information from customer invoices, and miscellaneous revenue, cash, and Receivables information from cash receipts to the General Ledger.

Default Account Sources

To minimize data entry errors, Oracle Applications provides many sources of default account information. These sources provide the default accounts that are utilized for subledger transactions, but can sometimes be overridden on the transaction itself.