Search Results mtl_pac_txn_cost_details




Overview
Explore in AI Chat

Overview

The MTL_PAC_TXN_COST_DETAILS table is a core transactional data store within the Oracle E-Business Suite Inventory (INV) module, specifically supporting the functionality of Periodic Average Costing (PAC). In Oracle EBS 12.1.1 and 12.2.2, this table serves as the detailed ledger for capturing and storing the granular cost breakdown of every inventory transaction that occurs within a PAC accounting period. Its primary role is to hold the cost details in a pending state during the period, which are then processed and finalized upon period close to calculate the new periodic average cost for items. This table is fundamental to the integrity of the PAC costing method, ensuring all material, resource, overhead, and outside processing costs are accurately tracked by transaction, item, and cost group.

Key Information Stored

The table's composite primary key structure defines the uniqueness of each cost detail record, linking it to a specific transaction, item, and costing context. The most critical columns include TRANSACTION_ID, which links to MTL_MATERIAL_TRANSACTIONS; INVENTORY_ITEM_ID; and COST_GROUP_ID, defining the costing entity. The PAC_PERIOD_ID associates the record with a specific open or closed costing period in CST_PAC_PERIODS. The COST_TYPE_ID indicates the type of cost (e.g., Frozen, Pending), while COST_ELEMENT_ID (Material, Resource, Overhead, Outside Processing) and LEVEL_TYPE break down the cost components. The table stores the actual cost amounts associated with each of these elements for the given transaction, forming the dataset for the period-end average cost calculation.

Common Use Cases and Queries

This table is primarily accessed for period-end costing processes, reconciliation, and troubleshooting. Common operational and reporting scenarios include analyzing pending transaction costs before closing a PAC period, investigating cost variances, and reconciling inventory valuations. A typical query pattern involves joining to transaction and master data tables to review cost details. For example, to analyze cost details for a specific period and item, a query would join MTL_PAC_TXN_COST_DETAILS with MTL_MATERIAL_TRANSACTIONS, MTL_SYSTEM_ITEMS_B, and CST_PAC_PERIODS, filtering on the relevant PAC_PERIOD_ID and INVENTORY_ITEM_ID. Reporting use cases focus on generating detailed cost ledgers and supporting audit trails for financial compliance.

Related Objects

As indicated by its foreign keys, MTL_PAC_TXN_COST_DETAILS has integral relationships with several key costing and inventory tables. It is a direct child of MTL_MATERIAL_TRANSACTIONS (TRANSACTION_ID). Its costing context is defined by references to CST_COST_GROUPS (COST_GROUP_ID), CST_PAC_PERIODS (PAC_PERIOD_ID), CST_COST_TYPES (COST_TYPE_ID), and CST_COST_ELEMENTS (COST_ELEMENT_ID). The table is heavily referenced by the Periodic Average Costing engine during the period close process (CSTPPACQ, CSTPPACR). For summarized reporting, views such as CST_PAC_COST_DETAILS_V may provide a more accessible layer. Data is typically populated via internal Inventory and Cost Management APIs, not via direct DML.