Search Results cst_item_costs_interface_pk

Overview

CST_ITEM_COSTS_INTERFACE is the open interface (staging) table used by the Bills of Material / Cost Management modules to load item cost information into Oracle EBS. It belongs to the BOM schema and resides alongside the core cost tables CST_ITEM_COSTS, CST_COST_TYPES, and CST_COST_UPDATES. The table is the entry point for external cost data—whether sourced from legacy conversions, third-party costing systems, or bulk maintenance routines—prior to validation and transfer into the permanent cost entities. Records are staged with the PROCESS_FLAG and TRANSACTION_ID columns controlling the disposition of each row during the import concurrent program.

From a modeling perspective, the FK structure suggests this object behaves as a link table: it associates items (MTL_SYSTEM_ITEMS_B), cost types (CST_COST_TYPES), and cost updates (CST_COST_UPDATES) with a composite business key. Its 62 documented columns are predominantly descriptive cost attributes rather than purely dependent measures, which is consistent with an interface link carrying reference context plus payload.

Key Information Stored

The primary key CST_ITEM_COSTS_INTERFACE_PK is a composite surrogate composed of GROUP_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, and COST_TYPE_ID. GROUP_ID groups a batch of rows submitted together, while the remaining three columns form the natural business key identifying the item, inventory organization, and cost type combination.

• GROUP_ID — batch identifier for a single interface run.
• INVENTORY_ITEM_ID / ORGANIZATION_ID — item and organization context (FK to MTL_SYSTEM_ITEMS_B).
• COST_TYPE_ID — cost type being loaded (FK to CST_COST_TYPES).
• COST_UPDATE_ID — owning cost update (FK to CST_COST_UPDATES).
• INVENTORY_ITEM / ITEM_NUMBER / ORGANIZATION_CODE / COST_TYPE — denormalized descriptive keys populated from the item and cost type definitions.
• MATERIAL_COST, MATERIAL_OVERHEAD_COST, RESOURCE_COST, OUTSIDE_PROCESSING_COST, OVERHEAD_COST — the elemental cost components.
• PL_ITEM_COST / TL_ITEM_COST / ITEM_COST — summarized cost at the item level.
• UNBURDENED_COST / BURDEN_COST — cost with and without overhead burden.
• LOT_SIZE, SHRINKAGE_RATE, BASED_ON_ROLLUP_FLAG, DEFAULTED_FLAG — costing control attributes.
• PROCESS_FLAG / TRANSACTION_ID / TRANSACTION_TYPE — interface processing status and action type (e.g., insert/update).
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program audit context.
• ATTRIBUTE1–ATTRIBUTE15 — DFF segments.

Common Use Cases and Queries

Typical scenarios include loading standard costs during implementation, importing updated costs from an external costing engine, and reconciling a batch before submission. Because the table is a staging link, queries generally precede the concurrent program that transfers rows into CST_ITEM_COSTS.

• Detect rows still pending processing: SELECT * FROM CST_ITEM_COSTS_INTERFACE WHERE PROCESS_FLAG IS NULL OR PROCESS_FLAG = 'N';
• Group a batch by run: SELECT GROUP_ID, COUNT(*) FROM CST_ITEM_COSTS_INTERFACE GROUP BY GROUP_ID;
• Validate the item/organization key against the system items: join CST_ITEM_COSTS_INTERFACE i to MTL_SYSTEM_ITEMS_B m ON i.INVENTORY_ITEM_ID = m.INVENTORY_ITEM_ID AND i.ORGANIZATION_ID = m.ORGANIZATION_ID.
• Verify cost type resolution: join to CST_COST_TYPES on COST_TYPE_ID.
• Confirm the cost update linkage: join to CST_COST_UPDATES on COST_UPDATE_ID.

Reporting frequently aggregates ITEM_COST, MATERIAL_COST, and OVERHEAD_COST per group and cost type to provide a pre-load cost summary for review.

Related Objects

The interface depends on and references the following principal objects through its documented foreign keys and interface context:

• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID to resolve item and organization identity.
• CST_COST_TYPES — joined on COST_TYPE_ID to resolve the costing method.
• CST_COST_UPDATES — joined on COST_UPDATE_ID to obtain the governing cost update.
• CST_ITEM_COSTS — the destination cost table populated after interface processing.
• MTL_PARAMETERS / ORG_ORGANIZATION_DEFINITIONS — organization context for the load.
• FND_CONCURRENT_REQUESTS — referenced via REQUEST_ID for audit of the import run.
• The Item Costs Interface concurrent program’s submission API — the mechanism that drives validation and transfer from this table into the cost entities.