Search Results cst_period_close_summary




Overview
Explore in AI Chat

Overview

CST_PERIOD_CLOSE_SUMMARY is a standalone table owned by the BOM schema in Oracle EBS 12.1.1 and 12.2.2. The table stores item-level period-end balances for summarized accounting periods, providing a persistent snapshot of inventory valuation at the point a cost period is closed. It is populated during the period-close and cost-rollup process, giving cost accountants and inventory analysts a consolidated record of accounted values, on-hand values, in-transit values, and rollback balances for each item, organization, cost group, and subinventory combination.

The heuristic Data Vault classification mined from the foreign key structure is standalone. This suggests modeling the table as an independent satellite-like structure rather than as a hub or link, since it contains a single documented reference to CST_COST_GROUPS and no downstream dependents within the mined FK graph. In practice, the natural composite of accounting period, organization, cost group, subinventory, and item functions as the effective primary key.

Because period-close data is retained for historical and audit reporting, the table supports reconciliation between perpetual inventory balances and the general ledger, and it enables period-over-period valuation analysis without recomputing cost distributions.

Key Information Stored

The documented schema exposes 25 columns. The most significant for business and reporting purposes are:

The surrogate primary key is not explicitly documented in the provided metadata; the business-key candidate is the composite of ACCT_PERIOD_ID, ORGANIZATION_ID, COST_GROUP_ID, SUBINVENTORY_CODE, and INVENTORY_ITEM_ID. COST_GROUP_ID is the only documented foreign key, referencing CST_COST_GROUPS.

Common Use Cases and Queries

Typical uses include period-end inventory valuation reporting, reconciliation of inventory to the general ledger, discrepancy analysis between accounted and rollback values, and historical trend analysis of on-hand and in-transit balances.

A representative query for period valuation by organization:

  • SELECT organization_id, cost_group_id, SUM(accounted_onhand_value), SUM(accounted_intransit_value) FROM cst_period_close_summary WHERE acct_period_id = :p_period GROUP BY organization_id, cost_group_id;

A discrepancy report isolating material variances:

  • SELECT inventory_item_id, onhand_value_discrepancy, intransit_value_discrepancy FROM cst_period_close_summary WHERE acct_period_id = :p_period AND (onhand_value_discrepancy <> 0 OR intransit_value_discrepancy <> 0);

Because the table is populated by concurrent close processes, rows should be filtered by ACCT_PERIOD_ID and ORGANIZATION_ID to scope reporting to the desired close cycle. The PROGRAM_ID and REQUEST_ID columns allow tracing a specific balance back to the concurrent request that generated it.

Related Objects

The most significant related objects, based on the documented foreign key and surrounding cost-management schema, include:

  • CST_COST_GROUPS — Joined via COST_GROUP_ID; defines the cost group segmentation used in the summary.
  • CST_PERIOD_CLOSE_HEADERS — Provides the header-level context (period, organization, close status) for summaries produced by the same close run.
  • CST_ITEM_COST_DETAILS — Source of item cost element detail that feeds the summarized values.
  • CST_QUANTITY_LAYERS — Underlying inventory and in-transit quantities used to derive accounted and rollback values.
  • MTL_SYSTEM_ITEMS_B — Joined on INVENTORY_ITEM_ID to resolve item descriptions and attributes.
  • ORG_ORGANIZATION_DEFINITIONS — Joined on ORGANIZATION_ID to resolve organization context.
  • MTL_SECONDARY_INVENTORIES — Joined on SUBINVENTORY_CODE and ORGANIZATION_ID to resolve subinventory detail.
  • GL_PERIODS / ORG_ACCT_PERIODS — Joined on ACCT_PERIOD_ID to resolve period names and dates.

These relationships support end-to-end reconciliation from transaction-level cost detail through to summarized period-close balances.