Search Results cst_pac_intorg_itms_temp_u1

Overview

BOM.CST_PAC_INTORG_ITMS_TEMP is a transient working table used by the Periodic Absorption Cost Processor (PACP) in Oracle EBS 12.1.1 and 12.2.2. It is owned by the BOM schema and stored in the APPS_TS_TX_DATA tablespace with an associated unique index, CST_PAC_INTORG_ITMS_TEMP_U1, residing in APPS_TS_TX_IDX. The object is classified as VALID and carries the FND Design Data identifier BOM.CST_PAC_INTORG_ITMS_TEMP.

The table supports the interorg transfer iteration process of the Periodic Absorption Cost Processor. PACP computes periodic item costs by iteratively resolving the cost impact of inter-organization receipts and shipments. Because a shipment out of one organization becomes a receipt in another, the processor must converge on a stable cost for each item across cost groups and periods. This table materializes the intermediate state of that convergence loop — prior cost, current cost, iteration count, divergence indicators, and tolerance flags — so the iterative solver can read its own prior results and determine whether to continue or terminate.

From a heuristic Data Vault perspective, the metadata indicates a standalone table with no outgoing referential constraints beyond its two foreign keys to CST_COST_GROUPS and CST_PAC_PERIODS. It is best modeled as a satellite-style staging object rather than a hub or link, because it is populated and consumed entirely within a single PACP run and its purpose is state tracking for an algorithmic process rather than long-lived master or relationship data.

Key Information Stored

• PAC_PERIOD_ID, COST_GROUP_ID, INVENTORY_ITEM_ID — The composite business key. The unique index CST_PAC_INTORG_ITMS_TEMP_U1 enforces uniqueness across these three columns, making them the canonical row identifier in the absence of a documented surrogate key sequence.
• ITEM_COST — The computed item cost for the given period, cost group, and item at the current iteration.
• PREV_ITR_ITEM_COST — The cost from the previous iteration, used to compute convergence.
• DIFFERENCE — The numeric gap between current and previous iteration item cost; drives the tolerance comparison.
• ITERATION_COUNT — Tracks how many passes the solver has made for the row.
• TOLERANCE_FLAG — Indicates whether the row has converged within allowable tolerance.
• DIVERGING_FLAG — Marks rows whose cost is diverging rather than converging, signalling a potential processing problem.
• INTERORG_RECEIPT_FLAG / INTERORG_SHIPMENT_FLAG — Identify whether the item participates in the interorg flow as a receiving or shipping side, controlling iteration logic.
• LOW_LEVEL_CODE — Low-level code of the inventory item specific to the cost group, used for sequence ordering.
• ABSORPTION_LEVEL_CODE — The Bill of Materials level to which the item is absorbed.
• SEQUENCE_NUM — The optimal sequence of the cost group within the iteration process.

Common Use Cases and Queries

Typical engagements with this table are diagnostic and troubleshooting-oriented. Cost analysts and support engineers inspect rows that have not converged, or that have been flagged as diverging, to explain runaway PACP runs or unexpected periodic costs for a given period and cost group.

Identifying diverging rows:

• SELECT PAC_PERIOD_ID, COST_GROUP_ID, INVENTORY_ITEM_ID, ITEM_COST, PREV_ITR_ITEM_COST, DIFFERENCE, ITERATION_COUNT FROM BOM.CST_PAC_INTORG_ITMS_TEMP WHERE DIVERGING_FLAG = 'Y';

Finding unconverged or tolerance-flagged entries:

• SELECT * FROM BOM.CST_PAC_INTORG_ITMS_TEMP WHERE TOLERANCE_FLAG IS NULL OR TOLERANCE_FLAG = 'N' ORDER BY PAC_PERIOD_ID, SEQUENCE_NUM;

Measuring iteration effort per cost group:

• SELECT COST_GROUP_ID, MAX(ITERATION_COUNT) FROM BOM.CST_PAC_INTORG_ITMS_TEMP GROUP BY COST_GROUP_ID;

Because the table is a working store, its contents normally reflect only the most recent or in-progress PACP execution and should not be treated as a permanent cost history source.

Related Objects

• CST_COST_GROUPS — joined on COST_GROUP_ID; provides cost group definitions.
• CST_PAC_PERIODS — joined on PAC_PERIOD_ID; defines the periodic absorption periods.
• BOM.CST_PAC_INTORG_ITMS_TEMP# — the underlying dependency object referenced by this table.

The documented metadata lists no views or APIs as dependents, and the table references no further database objects beyond the two foreign keys above. Consumers are the PACP concurrent process and its diagnostics rather than general-purpose cost reporting tables.