Oracle Applications: Financials Shared Entities/Data Flow between Applications

Oracle Application has shared items/entities across applications for the right integration and the data flow. Below are some of the shared entities that play major role in financial applications Integration.

• Suppliers:  Suppliers are defined AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL and AP_SUPPLIER_CONTACTS tables and shared across Purchasing, Payables, Asset etc. Applications

• Accounts: Financial Accounts (Numbers) are defined in GL_CODE_COMBINATIONS table and shared across all applications

• Items: Items are defined in INV application MTL_SYSTEM_ITEMS table and is shared by Order Management, Receivables , Purchasing, Inventory etc. applications

• Customers: Customers are defined in HZ_PARTIES table (As part of R12 TCA Trading Community Architecture changes) and shared across Order Management, Receivables etc. applications

Data Flow (Between Applications)

1. P2P : Purchasing -> Payables: When Invoices are received and matched against purchase order receipts or shipments data is copied into payables tables from Purchasing tables
2. P2A: Purchasing -> Assets: Asset records will be created out of the data entered in Payables for asset items(Factory, Building, Machine, Vehicle etc)
3. O2I: Order Mgmt to Inventory: Inventory is adjusted when items are shipped out to customers based on the orders processed in Order Mgmt application
4. O2R: Order Mgmt to Receivables: Once orders/items are shipped, receivables interface and autoinvoice processes will be run to generate customer invoices.

Data Flow (To General Ledger)

• Purchasing sends accrued (For material received but not yet delivered or billed)receipt information to GL
• Payables sends Invoice(Expense and Liability) data and Payments(Cash and Liability) data to GL
• Assets pass information on Asset Addition, Adjustments, Modification etc to GL
• Inventory passes financial data on material receipts, shipments etc to GL
• Order Mgmt passes the data to GL after the order has been shipped
• Receivables send revenue and sales data to GL