Search Results cst_pac_intorg_itms_temp




Overview
Explore in AI Chat

Overview

CST_PAC_INTORG_ITMS_TEMP is a transient staging table owned by the BOM schema within the Bills of Material product family of Oracle E-Business Suite. As its description in the ETRM documentation states, it is "used in the interorg transfer iteration procedure." The table supports Periodic Average Cost (PAC) processing, which computes item costs across a defined cost group and cost period. During the cost rollup iteration, Oracle must reconcile inventory balances that move between organizations through inter-organization transfers. Because an item's cost in a receiving organization depends on the cost in the shipping organization, the calculation is inherently iterative: the procedure loads affected item/cost-group/period combinations into this temporary table, cycles through successive iterations until costs converge within tolerance, and then posts the final results back to the permanent PAC cost tables.

The Data Vault classification supplied in the relationship metadata is standalone, based on a heuristic analysis of the foreign key structure. As a modeling suggestion, this table behaves as a standalone work table rather than a hub, link, or satellite: it carries a single natural key (the period/cost-group/item combination) and does not participate in a formal many-to-many relationship network, though it does reference two dimension-like parents. Its temporary, run-scoped nature means rows are effectively disposable once the PAC process completes.

Key Information Stored

The table exposes 14 documented columns. The business-key candidate is defined by the unique index CST_PAC_INTORG_ITMS_TEMP_U1 over (PAC_PERIOD_ID, COST_GROUP_ID, INVENTORY_ITEM_ID), which uniquely identifies one item's costing position within a given cost group and PAC period. No separate surrogate primary key is documented.

  • INVENTORY_ITEM_ID – the item being costed; part of the unique key.
  • COST_GROUP_ID – foreign key to CST_COST_GROUPS, defining the cost group scope; part of the unique key.
  • PAC_PERIOD_ID – foreign key to CST_PAC_PERIODS, identifying the PAC period; part of the unique key.
  • ITEM_COST – the item cost computed in the current iteration.
  • PREV_ITR_ITEM_COST – the cost from the prior iteration, retained for convergence comparison.
  • DIFFERENCE – the delta between the current and prior iteration cost, central to wrap-up tolerance testing.
  • TOLERANCE_FLAG – indicates whether the current difference falls within acceptable tolerance.
  • ITERATION_COUNT – the iteration in which the row was last computed.
  • LOW_LEVEL_CODE – the item's low-level code, governing the order of cost propagation.
  • ABSORPTION_LEVEL_CODE – the absorption level used in cost rollup sequencing.
  • INTERORG_RECEIPT_FLAG and INTERORG_SHIPMENT_FLAG – mark whether the item is involved in inter-organization receipts or shipments in the period.
  • DIVERGING_FLAG – flags items whose costs are not converging.
  • SEQUENCE_NUM – ordering of processing within the iteration.

Common Use Cases and Queries

The primary use case is diagnostic and performance tuning of PAC cost runs. Because the table is populated only while the interorg transfer iteration procedure executes, it is most valuable for troubleshooting items whose costs fail to converge or for auditing the iteration history of a specific run.

A typical query inspects items still flagged as unresolved:

  • Items exceeding tolerance: SELECT INVENTORY_ITEM_ID, COST_GROUP_ID, PAC_PERIOD_ID, ITEM_COST, PREV_ITR_ITEM_COST, DIFFERENCE, ITERATION_COUNT FROM BOM.CST_PAC_INTORG_ITMS_TEMP WHERE TOLERANCE_FLAG = 'N' ORDER BY DIFFERENCE DESC;
  • Non-converging items: filter on DIVERGING_FLAG = 'Y' or on a high ITERATION_COUNT.
  • Interorg impact analysis: filter where INTERORG_RECEIPT_FLAG = 'Y' OR INTERORG_SHIPMENT_FLAG = 'Y' to see which items drive the iteration.

Reports commonly join back to CST_PAC_PERIODS and CST_COST_GROUPS to present the period and group description alongside the item.

Related Objects

The following objects are most significant, derived from the documented foreign keys and PK relationships:

  • CST_COST_GROUPS – joined on COST_GROUP_ID.
  • CST_PAC_PERIODS – joined on PAC_PERIOD_ID.
  • MTL_SYSTEM_ITEMS_B – master item definition, joined on INVENTORY_ITEM_ID.
  • CST_ITEM_COSTS – permanent frozen/current item cost data, used for comparison against computed ITEM_COST.
  • MTL_INTERORG_PARAMETERS and MTL_MATERIAL_TRANSACTIONS – source of inter-organization shipment and receipt activity underlying the INTERORG_*_FLAG columns.
  • The PAC cost rollup concurrent program and its PL/SQL iteration procedure, which populate and consume this table during execution.