Search Results mtl_transaction_accounts

Overview

The MTL_TRANSACTION_ACCOUNTS table is a core transactional data repository within the Oracle E-Business Suite Inventory (INV) module. It functions as the detailed accounting distribution table for material transactions, storing the financial impact of inventory movements. Every material transaction recorded in MTL_MATERIAL_TRANSACTIONS that has accounting consequences generates one or more corresponding distribution records in this table. Its primary role is to capture the cost elements, amounts, and associated general ledger accounts for transactions, serving as the critical link between inventory operations and the General Ledger.

Key Information Stored

The table stores detailed accounting distributions for each inventory transaction. Key columns include TRANSACTION_ID, which links to the source transaction in MTL_MATERIAL_TRANSACTIONS, and REFERENCE_ACCOUNT, a foreign key to GL_CODE_COMBINATIONS that holds the specific general ledger account charged or credited. The COST_ELEMENT_ID (linking to CST_COST_ELEMENTS) identifies the type of cost, such as material, overhead, or resource. The table also holds the monetary AMOUNT for the distribution, along with CURRENCY_CODE. Other significant foreign keys include INVENTORY_ITEM_ID and ORGANIZATION_ID (to MTL_SYSTEM_ITEMS_B), RESOURCE_ID, ACTIVITY_ID, and identifiers for the transaction source (TRANSACTION_SOURCE_TYPE_ID) and associated WIP jobs (REPETITIVE_SCHEDULE_ID).

Common Use Cases and Queries

This table is central to cost accounting, financial reporting, and transaction auditing. Common use cases include reconciling inventory valuations to the general ledger, analyzing cost composition for issued components, and troubleshooting account generation errors. A fundamental query retrieves the full accounting breakdown for a specific transaction or item:

• SELECT mta.transaction_id, mta.cost_element_id, mta.amount, gcc.segment1, gcc.segment2 FROM mtl_transaction_accounts mta, gl_code_combinations gcc WHERE mta.reference_account = gcc.code_combination_id AND mta.transaction_id = :p_transaction_id;

For period-end close, analysts often aggregate amounts by cost element and account to validate inventory balances. Integration with the Cost Management module relies heavily on this table to assess cost flows and variances.

Related Objects

MTL_TRANSACTION_ACCOUNTS has extensive relationships with other EBS entities, as indicated by its foreign keys. Its primary parent is MTL_MATERIAL_TRANSACTIONS. For accounting, it directly references GL_CODE_COMBINATIONS and ORG_GL_BATCHES. For item and organizational context, it links to MTL_SYSTEM_ITEMS_B. For Work in Process (WIP) integration, it references WIP_REPETITIVE_SCHEDULES. Key cost-related references include CST_COST_ELEMENTS, BOM_RESOURCES, and CST_ACTIVITIES. The table is also central to the transaction source model via MTL_TXN_SOURCE_TYPES and to currency information via FND_CURRENCIES.