Results for “quantity_layer_id”

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

Overview

CST_PAC_PERIOD_BALANCES is a cost management table owned by the BOM schema in Oracle E-Business Suite. It stores Periodic Average Cost (PAC) period balances for transaction categories, holding the summarized quantity, cost, and variance figures that result from the PAC cost accumulation process for a given period, cost group, and item. The table acts as the persistent store for periodic costing balances, enabling cost accountants to reconcile inventory movements and cost variances at the transaction-category level rather than at the individual transaction level.

Under the heuristic Data Vault classification derived from its foreign-key structure, the table is modeled as a standalone entity. This reflects an absence of dependent children in the mined relationship graph: CST_PAC_PERIOD_BALANCES is itself a leaf-level fact-style table that references dimensional parents (period, cost group, cost layer) but is not referenced by downstream tables. Practically, this suggests it behaves as a satellite-like balance repository anchored to PAC period and cost group dimensions, rather than acting as a hub or link in the integration sense.

Key Information Stored

The 23 documented columns capture the dimensional keys, transactional category bucketing, and the derived monetary and quantity balances. The most significant columns are:

• PAC_PERIOD_ID — Foreign key to CST_PAC_PERIODS; identifies the PAC period for which the balance is held. This is a principal business-key component.
• COST_GROUP_ID — Foreign key to CST_COST_GROUPS; identifies the cost group whose items are being accumulated.
• INVENTORY_ITEM_ID — The inventory item to which the balance applies.
• COST_LAYER_ID — Foreign key to CST_PAC_ITEM_COSTS; ties the balance to the item cost layer used in periodic averaging.
• QUANTITY_LAYER_ID — Associates the balance with a specific quantity layer within the cost layer structure.
• COST_ELEMENT_ID — The cost element (material, material overhead, resource, overhead, outside processing) to which the balance pertains.
• LEVEL_TYPE — Indicates the costing level type for which the balance is calculated.
• TXN_CATEGORY — The transaction category (for example, receipt, issue, adjustment) that drives the summarized balance.
• TXN_CATEGORY_QTY and TXN_CATEGORY_VALUE — The accumulated quantity and value attributable to the transaction category.
• PERIOD_QUANTITY — The total quantity for the period at the grouped level.
• PERIODIC_COST — The periodic average unit cost derived for the period.
• PERIOD_BALANCE — The residual period balance after applying movements.
• VARIANCE_AMOUNT — The variance amount recognized for the period, typically arising from the difference between actual and periodic average costs.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, and the PROGRAM_* columns — Standard EBS who-columns and concurrent program audit context.

The documented FK structure indicates that the composite of PAC_PERIOD_ID, COST_GROUP_ID, INVENTORY_ITEM_ID, and COST_LAYER_ID functions as the effective business key, while no single surrogate primary key column is separately named in the metadata. Implementations typically enforce uniqueness across this dimensional combination via a unique index.

Common Use Cases and Queries

Cost accountants and developers rely on this table for periodic cost reconciliation, variance analysis, and period-close reporting. Typical queries join the table to its dimensional parents to resolve descriptive attributes.

• Period balance inquiry: Select balance rows for a given PAC period and cost group to review quantities and values by transaction category.
• Variance reporting: Aggregate VARIANCE_AMOUNT by cost element or item to explain period variances against periodic average costs.
• Cost group roll-up: Join to CST_COST_GROUPS to report balances across all items in a cost group.
• Item cost layer tie-out: Join COST_LAYER_ID to CST_PAC_ITEM_COSTS to reconcile period balances back to the underlying item cost layers.

A representative pattern is: SELECT b.INVENTORY_ITEM_ID, b.TXN_CATEGORY, b.TXN_CATEGORY_QTY, b.TXN_CATEGORY_VALUE, b.VARIANCE_AMOUNT FROM CST_PAC_PERIOD_BALANCES b WHERE b.PAC_PERIOD_ID = :period_id AND b.COST_GROUP_ID = :cost_group_id;

Related Objects

The documented foreign keys define the principal related objects:

• CST_PAC_PERIODS — joined via PAC_PERIOD_ID; the master period definition.
• CST_COST_GROUPS — joined via COST_GROUP_ID; defines the cost group grouping.
• CST_PAC_ITEM_COSTS — joined via COST_LAYER_ID; supplies the item cost layer used in periodic averaging.

Additional dependencies implied by the columns include the inventory item master (INVENTORY_ITEM_ID) and cost element definitions (COST_ELEMENT_ID), which are resolved through standard EBS item and cost element views. Because the table is classified as standalone, it does not itself serve as a parent for dependent child tables, but it is consumed by cost reporting and period-close concurrent programs within the BOM/Costing modules.