CAC Resources Associated with Overheads Setup – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Report to show which resources are associated with which overheads and which resources are associated with which departments. And find any resources which do not have any overhead associations. If there are no overhead associations the first report column will say “Missing”. If the resource/overhead association exists, the first column of the report will say “Set Up”.

Note: if a resource does not have a cost, the Resource Rate column has a blank or empty value.

Parameters:

Resource/Overhead Cost Type: enter the cost type you wish to report for your resources and overheads. If left blank, depending on your Costing Method, it defaults to your AvgRates or Frozen Cost Type (optional). Category Set 1: any item category you wish, typically the Cost or Product Line category set (optional). Category Set 2: any item category you wish, typically the Inventory category set (optional). Organization Code: enter the specific inventory organization(s) you wish to report (optional). Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional).

/* +=============================================================================+ – | Copyright 2016 - 2024 Douglas Volz Consulting, Inc. – | All rights reserved. – | Permission to use this code is granted provided the original author is – | acknowledged. No warranties, express or otherwise is included in this permission. – +=============================================================================+ – | – | Original Author: Douglas Volz (doug@volzconsulting.com) – | – | Program Name: xxx_res_ovhd_setup.sql – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 11 Nov 2016 Douglas Volz Initial Coding – | 1.1 16 Jun 2017 Douglas Volz Add check for resources which are not – | associated with overheads and added the – | resource cost element. – | 1.2 17 Jul 2018 Douglas Volz Made Cost Type parameter optional – | 1.3 16 Jan 2020 Douglas Volz Added org code and operating unit parameters. – | 1.4 20 Apr 2020 Douglas Volz Make Cost Type default work for all cost methods – | 1.5 09 Jul 2022 Douglas Volz Changes for multi-language lookup values. – | 1.6 22 Jan 2024 Douglas Volz Add with statement for cst_resource_costs, overheads – | were not reported if the resource cost was missing. – | Added resource “Allow Costs” column. Removed – | tabs and added inventory access controls. – | 1.7 31 Jan 2024 Douglas Volz Add Currency Code, Resource Type and Charge Type columns. – +=============================================================================+*/

Report Parameters

Resource/Overhead Cost Type, Organization Code, Operating Unit, Ledger

Oracle EBS Tables Used

cst_resource_overheads, bom_department_resources, bom_departments, crc, bom_resources, cst_cost_types, cst_cost_elements, mtl_parameters, mfg_lookups, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, fnd_lookup_values, org_access_view, fnd_common_lookups

Report Categories

Enginatics

CAC Manufacturing Variance, CAC Department Overhead Setup, CAC Department Overhead Setup Errors, CAC Resources by Department Setup, CAC WIP Resource Efficiency, CAC Department Overhead Rates, CAC Item Cost & Routing, CST Supply Chain Indented Bills of Material Cost, CAC WIP Account Detail

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output CAC Resources Associated with Overheads Setup 08-Jul-2022 194540.xlsx
Blitz Report™ XML Import CAC_Resources_Associated_with_Overheads_Setup.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-resources-associated-with-overheads-setup/

Case Study & Technical Analysis: CAC Resources Associated with Overheads Setup

Executive Summary

The CAC Resources Associated with Overheads Setup report is a configuration audit tool. In Oracle Costing, Overheads (like “Factory Burden”) are often applied based on Resource usage (e.g., “$10 of Overhead for every 1 hour of Labor”). This report validates that the links between Resources and Overheads are correctly established.

Business Challenge

Solution

This report visualizes the matrix.

Technical Architecture

Parameters

Performance

FAQ

Q: Can a resource have multiple overheads? A: Yes, Labor might attract “Fringe”, “Supervision”, and “Occupancy” overheads. All will be listed.

© 2026 Enginatics