Search Results mtl_pac_txn_cost_details




Overview
Explore in AI Chat

Overview

The CST_PAC_PERIODS table is a core data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Bills of Material (BOM) product module. It serves as the master control table for Periodic Average Costing (PAC), a key inventory valuation method. Its primary role is to define and manage the open and closed costing periods for each legal entity within the organization. By establishing these discrete accounting periods, the table enables the system to accumulate and average material and manufacturing costs over a period, which are then used to value inventory transactions and balances. The integrity of the entire periodic costing process is anchored to the periods defined in this table.

Key Information Stored

The table's primary key is the system-generated PAC_PERIOD_ID, which uniquely identifies each costing period record. The most critical columns define the period's context and status. These include LEGAL_ENTITY, which links to HR_ALL_ORGANIZATION_UNITS to identify the organization; COST_TYPE_ID, which references CST_COST_TYPES to specify the average cost type; and PERIOD_SET_NAME and PERIOD_NAME, which link to GL_PERIODS to synchronize with the general ledger accounting calendar. Other essential columns track the period's operational state, such as the PERIOD_CLOSE_DATE and flags indicating whether the period is open for transaction processing, closed, permanently closed, or pending final closure. This structure ensures cost calculations are segregated and controlled by legal entity, cost type, and time period.

Common Use Cases and Queries

A primary use case is validating the status of a costing period before running critical processes like the Cost Processor or generating period-end reports. Administrators frequently query this table to list open periods or identify periods pending closure. Common SQL patterns include checking period status for a specific entity and cost type, or joining with GL_PERIODS for detailed reporting.

  • Finding open periods for a legal entity: SELECT period_name, period_start_date FROM cst_pac_periods WHERE legal_entity = :p_org_id AND cost_type_id = :p_cost_type AND open_flag = 'Y';
  • Identifying periods with pending transactions before closure: SELECT period_name FROM cst_pac_periods WHERE legal_entity = :p_org_id AND pending_close_flag = 'Y';
  • Reporting on period statuses alongside GL dates: SELECT cpp.period_name, glp.start_date, glp.end_date, cpp.open_flag FROM cst_pac_periods cpp, gl_periods glp WHERE cpp.period_set_name = glp.period_set_name AND cpp.period_name = glp.period_name;

Related Objects

CST_PAC_PERIODS has extensive relationships, acting as a parent table for numerous transactional and balance tables in the costing schema. As per the provided metadata, its primary key (PAC_PERIOD_ID) is referenced by key PAC working and storage tables, including CST_PAC_ITEM_COSTS, CST_PAC_QUANTITY_LAYERS, and WIP_PAC_PERIOD_BALANCES. It is also referenced by process control tables like CST_PAC_PROCESS_PHASES and detail tables for actual costs, such as MTL_PAC_ACTUAL_COST_DETAILS and WIP_PAC_ACTUAL_COST_DETAILS. Furthermore, it maintains foreign key relationships to foundational setup tables: CST_COST_TYPES (COST_TYPE_ID), HR_ALL_ORGANIZATION_UNITS (LEGAL_ENTITY), and GL_PERIODS (PERIOD_SET_NAME, PERIOD_NAME). This web of dependencies underscores its central role in the Periodic Average Costing architecture.