Results for “cst_resource_costs”

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

Overview

CST_RESOURCE_COSTS is a table owned by the BOM (Bills of Material) schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It stores the cost definition for manufacturing resources and outside processing resources, providing the rate that the costing engine applies when a resource is consumed on a work order, routing, or flow schedule. The table is registered as VALID in the ETRM repository and belongs functionally to the BOM product family, although it is consumed directly by Oracle Cost Management and by the Bills of Material resource maintenance forms.

Each row associates a specific resource with a specific cost type and an organization, allowing the same resource to carry different rates per cost type (for example Frozen, Average, or user-defined cost types) and, where applicable, per inventory organization. Heuristically mined from its foreign key structure, the table is best modeled as a link in a Data Vault design — it resolves the many-to-many relationship between resources and cost types rather than acting as a standalone hub entity. This classification is a modeling suggestion only and is not part of the delivered schema metadata.

Key Information Stored

The physical schema documents 29 columns. The most significant are:

• RESOURCE_ID — refers to the resource definition in BOM_RESOURCES; part of the composite primary key.
• COST_TYPE_ID — refers to CST_COST_TYPES; the second component of the composite primary key.
• ORGANIZATION_ID — the inventory organization to which the resource cost applies.
• RESOURCE_RATE — the actual cost rate charged for the resource under the given cost type.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context that last touched the row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the flexible descriptive flexfield segment container.

The surrogate primary key is the composite CST_RESOURCE_COSTS_PK (RESOURCE_ID, COST_TYPE_ID). Two unique indexes serve as business-key candidates: CST_RESOURCE_COSTS_U1 (RESOURCE_ID, COST_TYPE_ID) and CST_RESOURCE_COSTS_U2 (ORGANIZATION_ID, COST_TYPE_ID, RESOURCE_ID). The U2 index indicates that organization is a meaningful discriminator in the business key, permitting organization-specific rates for the same resource/cost type pair.

Common Use Cases and Queries

Typical usage includes validating resource rates before a cost rollup, reconciling costed work orders to the resource rates in effect, and building rate history reports across cost types.

• Retrieve all rates for a resource: SELECT cost_type_id, organization_id, resource_rate FROM cst_resource_costs WHERE resource_id = :resource_id;
• Join to resource master to obtain names: SELECT r.resource_code, c.cost_type_id, c.resource_rate FROM cst_resource_costs c, bom_resources r WHERE c.resource_id = r.resource_id;
• Audit recent changes by program: SELECT * FROM cst_resource_costs WHERE program_id = :program_id AND last_update_date > :cutoff;
• Identify organization-specific overrides using the U2 key columns.

Reporting consumers include resource rate listings per cost type, cost rollup variance analysis, and outside processing cost simulations. Because the table is populated through resource cost maintenance and concurrent cost programs, queries should filter by cost type to avoid mixing incompatible rate bases.

Related Objects

• BOM_RESOURCES — referenced via CST_RESOURCE_COSTS.RESOURCE_ID; the resource master.
• CST_COST_TYPES — referenced via CST_RESOURCE_COSTS.COST_TYPE_ID; defines the cost type context.
• ORG_ORGANIZATION_DEFINITIONS — supplies the organization context implied by ORGANIZATION_ID.
• Resource cost maintenance forms and the resource cost concurrent programs that write to this table.
• Cost rollup and work-order costing processes that read executed resource rates from this table.