Results for “begin_item_cost”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CST_PC_ITEM_COST_INTERFACE table is a Periodic Costing interface table owned by the BOM (Bills of Material) schema in Oracle E-Business Suite. It is documented as the "Periodic Item Cost Header Interface Table" and operates as a staging and header structure that supports Oracle's Periodic Costing (PAC) process. In EBS 12.1.1 and 12.2.2, this table bridges transactional cost activity and the periodic cost layer calculations performed by the Cost Management application. It is populated by periodic costing programs and consumed during the calculation, validation, and import of item costs into the period-end costing cycle for an inventory organization.

From a heuristic Data Vault modeling perspective, the table is classified as standalone, reflecting that its mined foreign-key structure does not cluster it within a broader hub-link-satellite constellation. It functions semantically as a staging interface with a single-column surrogate primary key, INTERFACE_HEADER_ID, ordered through the CST_PC_ITEM_COST_INTERFACE_PK constraint. The table contains 54 documented columns and is physically owned by the BOM schema, which is significant because BOM is the historical schema host for many cost-related objects in EBS.

Key Information Stored

The table holds cost header records tied to a specific item, cost group, cost type, and accounting period. Key columns include:

• INTERFACE_HEADER_ID — the surrogate primary key and unique business-key candidate, identifying each interface header row.
• INVENTORY_ITEM_ID — the item whose cost is being interfaced.
• COST_GROUP and COST_GROUP_ID — the cost group classification for periodic costing.
• COST_TYPE — the cost type context, such as Frozen or Average.
• PERIOD_NAME — the accounting period to which the interface record belongs.
• PROCESS_FLAG — the processing status used by the periodic costing program to select and update rows.
• COST_LAYER_ID and QUANTITY_LAYER_ID — references to the cost layer and quantity layer involved in the calculation.
• PAC_PERIOD_ID — a foreign-key reference to CST_PAC_PERIODS, identifying the periodic costing period.
• ITEM_COST, BEGIN_ITEM_COST, and PL_ITEM_COST / TL_ITEM_COST — cost amounts at beginning, item, and prior/translated layer levels.
• ERROR_FLAG and ERROR_EXPLANATION — validation diagnostics generated during processing.
• LOCK_FLAG — concurrency control indicator preventing simultaneous processing.
• Audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and REQUEST_ID — standard EBS who-columns that trace the concurrent request that populated the row.

Common Use Cases and Queries

Typical usage centers on monitoring the progress of periodic costing runs, troubleshooting failed cost interfaces, and reconciling periodic cost amounts. A common query inspects unprocessed rows for a given period and cost group:

• SELECT INTERFACE_HEADER_ID, INVENTORY_ITEM_ID, PERIOD_NAME, COST_GROUP, PROCESS_FLAG, ITEM_COST FROM CST_PC_ITEM_COST_INTERFACE WHERE PERIOD_NAME = :p AND PROCESS_FLAG = 'N';
• Error diagnostics retrieval: SELECT INTERFACE_HEADER_ID, ERROR_FLAG, ERROR_EXPLANATION FROM CST_PC_ITEM_COST_INTERFACE WHERE ERROR_FLAG = 'Y';
• Concurrency investigation: filter on LOCK_FLAG = 'Y' to identify rows held by active processing.
• Audit tracing: join on REQUEST_ID to the concurrent request table to identify the originating costing program.

Reporting use cases include period-close cost reconciliation, variance analysis between PL_ITEM_COST and TL_ITEM_COST, and material versus overhead cost decomposition using the material, resource, overhead, and outside processing columns.

Related Objects

The documented foreign-key references identify several dependent cost objects:

• CST_PAC_PERIODS — referenced via PAC_PERIOD_ID; defines the periodic costing period master.
• CST_PAC_ITEM_COSTS — referenced via COST_LAYER_ID; holds calculated periodic item cost layer details.
• CST_COST_GROUPS — referenced via COST_GROUP_ID; provides cost group definitions.

The table also relates semantically to the Cost Management periodic costing concurrent programs and to inventory item master data through INVENTORY_ITEM_ID. Analysts frequently join it with MTL_SYSTEM_ITEMS_B for item descriptions and with CST_ITEM_COSTS for comparison against perpetual cost records.