Results for “accounted_onhand_value”

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

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:

• ACCT_PERIOD_ID — The accounting period to which the summarized balances belong (joins to GL/ORG period definitions).
• ORGANIZATION_ID — The inventory organization owning the item balance.
• COST_GROUP_ID — References CST_COST_GROUPS; partitions balances by cost group.
• SUBINVENTORY_CODE — The subinventory within which the item balance is held.
• INVENTORY_ITEM_ID — The item being summarized.
• ACCOUNTED_VALUE — The accounted inventory value recorded at period close.
• ACCOUNTED_ONHAND_VALUE and ACCOUNTED_INTRANSIT_VALUE — The on-hand and in-transit portions of the accounted value.
• ROLLBACK_VALUE, ROLLBACK_QUANTITY, ROLLBACK_ONHAND_VALUE, ROLLBACK_INTRANSIT_VALUE — Values and quantities used when reversing or comparing the prior period's close.
• ONHAND_VALUE_DISCREPANCY and INTRANSIT_VALUE_DISCREPANCY — Variances between accounted and rollback positions, used in reconciliation.
• CUMULATIVE_ONHAND_MTA and CUMULATIVE_INTRANSIT_MTA — Cumulative material and overhead absorption amounts for on-hand and in-transit inventory.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Concurrent program audit trail identifying the close process that produced the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATION_BY — Standard auditing columns.

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.