Search Results cst_resource_overheads




Overview
Explore in AI Chat

Overview

CST_RESOURCE_OVERHEADS is a Bills of Material (BOM) schema table in Oracle E-Business Suite that defines the relationship between a resource and the overhead(s) applied to it. In Oracle EBS costing and manufacturing, overheads are indirect costs that are absorbed into the cost of a manufactured item based on the activity of resources. This table records, for a given resource, which overhead should be applied and under which cost type. It is a foundational configuration table consumed by the Cost Management (CST) costing engine when resource-level overhead absorption is calculated, particularly for standard costing and average costing organizations.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as a link table. This is appropriate: CST_RESOURCE_OVERHEADS does not represent a business entity or hub in its own right; rather, it resolves a many-to-many association between resources, cost types, and overheads. A Data Vault model would treat it as a link entity joining the resource and cost type hubs through the overhead relationship.

Key Information Stored

The table contains 29 documented columns, most of which are standard EBS audit and descriptive flexfield (DFF) columns. The following are the most significant:

The surrogate primary key is CST_RESOURCE_OVERHEADS_PK, defined over (RESOURCE_ID, COST_TYPE_ID, OVERHEAD_ID). A unique index, CST_RESOURCE_OVERHEADS_U1, is documented over the same three columns, which serves as the business-key candidate ensuring a given overhead is not applied more than once to the same resource/cost type combination.

Common Use Cases and Queries

Typical uses include validating overhead setup prior to cost rollup, troubleshooting missing overhead absorption on a work order, and generating configuration reports for manufacturing costing.

  • Listing all overheads assigned to a specific resource:

    SELECT overhead_id FROM cst_resource_overheads WHERE resource_id = :resource_id AND cost_type_id = :cost_type_id;

  • Joining to BOM_RESOURCES to retrieve overhead resource names and to CST_COST_TYPES for cost type descriptions.
  • Reporting the overhead-to-resource matrix across organizations using ORGANIZATION_ID as a filter.
  • Auditing recently changed configurations via CREATION_DATE, LAST_UPDATE_DATE, and PROGRAM_ID.

Related Objects

The table integrates primarily with the following EBS objects:

  • BOM_RESOURCES — Referenced twice, via RESOURCE_ID (the base resource) and OVERHEAD_ID (the overhead resource definition).
  • CST_COST_TYPES — Via COST_TYPE_ID, defining the costing environment for the association.
  • CST_ITEM_COSTS and cost rollup processes — Downstream consumers that apply the overhead during item cost calculation.
  • BOM_RESOURCE_OVERHEADS or equivalent resource-overhead assignment logic — Related configuration that governs how overhead rates drive absorption.
  • CST_OVERHEAD_DEFAULTS / default overhead setup — Organizational defaults that may be overridden at the resource level by this table.

Together, these relationships make CST_RESOURCE_OVERHEADS a critical link in the EBS manufacturing costing chain, connecting resource definition, cost type, and overhead absorption rules.