Search Results cst_department_overheads

Overview

The CST_DEPARTMENT_OVERHEADS table is a core data object within the Bills of Material (BOM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for defining and storing overhead costs associated with manufacturing departments. This table is fundamental to the Cost Management functionality, enabling the assignment of specific overhead rates—such as for utilities, supervision, or equipment depreciation—to departments based on cost types and activities. By linking departments, cost types, and overhead resources, it provides the foundational data required for accurate product cost roll-ups, variance analysis, and period-end accounting close processes.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which enforce critical business rules. The primary key is a composite of DEPARTMENT_ID, COST_TYPE_ID, and OVERHEAD_ID, ensuring a unique overhead definition per department and cost type combination. Key columns include DEPARTMENT_ID (linking to BOM_DEPARTMENTS), COST_TYPE_ID (linking to CST_COST_TYPES), and OVERHEAD_ID (linking to BOM_RESOURCES to identify the overhead resource). An important optional column is ACTIVITY_ID, which links to CST_ACTIVITIES, allowing for Activity-Based Costing (ABC) where overheads are applied based on specific departmental activities. The table typically also stores the associated overhead rate or amount for the defined relationship.

Common Use Cases and Queries

Primary use cases involve cost setup, inquiry, and reporting. During implementation or maintenance, cost accountants use this table to define standard or frozen overhead rates for departments. Common operational queries include listing all overheads assigned to a specific department for a given cost type or validating setup before a cost update. A typical reporting query might join to related tables to produce a departmental overhead summary:

• SELECT d.department_code, ct.cost_type, r.resource_code, cdoh.overhead_rate FROM bom.cst_department_overheads cdoh JOIN bom.bom_departments d ON cdoh.department_id = d.department_id JOIN cst.cst_cost_types ct ON cdoh.cost_type_id = ct.cost_type_id JOIN bom.bom_resources r ON cdoh.overhead_id = r.resource_id WHERE ct.cost_type = 'Frozen';

This data is critical for generating costed bills of material and analyzing manufacturing overhead absorption.

Related Objects

CST_DEPARTMENT_OVERHEADS is centrally connected to several key master and transactional tables via foreign key constraints, as documented in the ETRM. The table BOM_DEPARTMENTS provides the valid manufacturing department list. CST_COST_TYPES defines the costing methods (e.g., Standard, Frozen). BOM_RESOURCES supplies the definition of the overhead resource itself. The optional link to CST_ACTIVITIES enables activity-based costing setups. This table is a direct input for cost calculation engines and is referenced by various cost roll-up and variance reporting programs within the Cost Management suite. Understanding these relationships is essential for troubleshooting data integrity issues or developing custom cost analyses.