Search Results mtl_consumption_transactions




The MTL_CONSUMPTION_TRANSACTIONS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for tracking consumption transactions within inventory and cost management modules. It stores data related to the movement of items from one subinventory to another, or for internal consumption purposes, such as production, maintenance, or scrap. This table is integral to inventory valuation, cost accounting, and reporting processes, ensuring accurate financial and operational tracking. ### **Key Attributes of MTL_CONSUMPTION_TRANSACTIONS** 1. **Transaction Identification** - TRANSACTION_ID: A unique identifier for each consumption transaction. - TRANSACTION_TYPE_ID: References the transaction type (e.g., "Subinventory Transfer," "Direct Consumption"). - TRANSACTION_DATE: The date and time the transaction was recorded. 2. **Item and Inventory Details** - INVENTORY_ITEM_ID: Links to MTL_SYSTEM_ITEMS_B to identify the consumed item. - ORGANIZATION_ID: Specifies the inventory organization where the transaction occurred. - SUBFUNCTION: Indicates the purpose (e.g., "Production," "Scrap"). 3. **Quantity and Cost Data** - TRANSACTION_QUANTITY: The quantity of items consumed. - PRIMARY_QUANTITY: Quantity in the primary unit of measure. - ACTUAL_COST: The unit cost at the time of consumption, critical for cost accounting. 4. **Source and Destination References** - SOURCE_SUBINVENTORY: The subinventory from which items were consumed. - DESTINATION_SUBINVENTORY: The target subinventory (if applicable). 5. **Documentation and Approval** - REFERENCE: User-defined reference (e.g., PO number, work order). - REASON_ID: Justification for the transaction (linked to MTL_TRANSACTION_REASONS). ### **Integration with Other Modules** The table interacts with: - **Cost Management (CST_ tables)**: Updates item costs and valuation. - **Work in Process (WIP)**: Tracks material consumption for production orders. - **General Ledger (GL)**: Posts accounting entries via the MTL_MATERIAL_TRANSACTIONS interface. ### **Technical Considerations** - **Indexes**: Optimized for queries on TRANSACTION_ID, INVENTORY_ITEM_ID, and ORGANIZATION_ID. - **Purge Policies**: Older transactions may be archived to maintain performance. ### **Business Impact** Accurate data in MTL_CONSUMPTION_TRANSACTIONS ensures: - Compliance with financial reporting standards (e.g., GAAP). - Real-time visibility into inventory levels and material usage. - Audit trails for internal controls and cost analysis. ### **Conclusion** This table is foundational for inventory and cost control in Oracle EBS, enabling precise tracking of material flows and supporting critical financial processes. Proper configuration and maintenance are essential for operational efficiency.