Item Reservation- (InSide View)

This article will help to understand table structure which supports Item reservations in Oracle E-business suite (R12).

Item Reservation Tables

• MTL_DEMAND : This table stores demand and reservation information used in Available to Promise, Planning, and other manufacturing functions. Four row types are stored in this table:

-                 Summary Demand rows

-                 Dependent Demand rows

-                 Open Demand rows

-                 Reservation rows

-                 The primary key is INVENTORY_ITEM_ID, DEMAND_SOURCE_TYPE, DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE (o), DEMAND_SOURCE_DELIVERY (o), COMPONENT_SEQUENCE_ID (o).

• MTL_SALES_ORDERS : This table stores the Oracle Inventory local definition of sales orders and maps sales orders between Oracle Inventory and other Oracle Manufacturing applications. The primary key is SALES_ORDER_ID.

• OE_ORDER_HEADERS_ALL : This table stores header information for orders in Oracle Order Management. The primary key is HEADER_ID.

• OE-ORDER_LINES_ALL : This table stores information for all order lines in Oracle Order Management. The primary key is LINE_ID.

• GL_CODE_COMBINATIONS : This table stores valid Accounting Flexfield segment value combinations for each accounting flexfield structure within your General Ledger application. Available material can be reserved against a valid Accounting Flexfield combination. The primary key is CODE_COMBINATION_ID.

• MTL_GENERIC_DISPOSITIONS : This table stores the user-defined account alias. An account alias provides a method to use accounting numbers and makes it easier to transact account issues and receipts. Available inventory can be reserved against an account alias. The primary key is DISPOSITION_ID, ORGANIZATION_ID.

• MTL_MATERIAL_TRANSACTIONS : This table stores a record of every material transaction or cost update performed in Inventory. An issue transaction to an account number or account alias can relieve a reservation against the account number or alias. The primary key is TRANSACTION_ID.

• MTL_DEMAND_INTERFACE : This table is the interface point between non-Inventory applications and the Oracle Inventory demand module. Records inserted into this table are processed by the Demand Manager concurrent program.

• MTL_SYSTEM_ITEMS_B : This table is the definition table for items. This table holds the definitions for inventory items, engineering items, and purchasing items. The primary key for an item is the INVENTORY_ITEM_ID and the ORGANIZATION_ID.

Inventory Transaction data flow

Inventory Transaction Tables
This article will help to understand table structure which supports material  transactions in Oracle E-business suite (R12). 

•       MTL_TRANSACTIONS_INTERFACE: This is the interface point between non-Inventory applications and the Inventory transaction module. The Transaction Manager concurrent program polls this table at a user-specified process interval and submits the transaction workers to process them. Processing consists of data derivation, validation, and transfer of records from MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_SERIAL_NUMBERS_INTERFACE into their respective TEMP tables, from where they are processed by the transaction processor.

•       MTL_MATERIAL_TRANSACTIONS_TEMP: This table is the gateway for all material transactions. Records are processed from this table into Inventory through the transaction processor. All Inventory transaction forms write directly to this table. Outside applications must write transaction records to MTL_TRANSACTSIONS_INTERFACE TXN Processor makes use of TXN worker to process the transactions from MTL_TRANSACTIONS_INTERFACE to MTL_MATERIAL_TRANSACTIONS_TEMP and from MTL_MATERIAL_TRANSACTIONS_TEMP to MTL_MATERIAL_TRANSACTIONS..

•       MTL_MATERIAL_TRANSACTIONS: This table stores a record of every material transaction or cost update performed in Inventory. Records are inserted into this table either through the transaction processor or by the standard cost program. The primary key is TRANSACTION_ID.

•       MTL_TRANSACTION_ACCOUNTS: This table holds the accounting information for each material transaction in MTL_MATERIAL_TRANSACTIONS. Oracle Inventory uses this information to track the financial impact of your quantity moves.