| layout | default |
|---|---|
| title | CAC Resources Associated with Overheads Setup | Oracle EBS SQL Report |
| description | Report to show which resources are associated with which overheads and which resources are associated with which departments. And find any resources which… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, CAC, Resources, Associated, Overheads, cst_resource_overheads, bom_department_resources, bom_departments |
| permalink | /CAC%20Resources%20Associated%20with%20Overheads%20Setup/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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.
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.
| -- +=============================================================================+ |
|---|
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- +=============================================================================+*/ |
Resource/Overhead Cost Type, Organization Code, Operating Unit, Ledger
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
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
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.
| 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/ |
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.
- Under-Absorption: If "Labor" is not linked to "Fringe Benefits", the product cost will exclude the benefit cost, leading to under-pricing.
- Complexity: A plant might have 50 resources and 10 overheads. Checking the 500 potential combinations manually is error-prone.
- Troubleshooting: "Why is the overhead calculation zero?"
This report visualizes the matrix.
- Mapping: Shows
Resource->Overhead. - Status: Explicitly flags "Missing" associations where a resource exists but has no overheads linked (if that is the business rule).
- Rates: Shows the basis (Item or Lot) and the rate.
- Tables:
cst_resource_overheads,bom_resources. - Logic: Uses a
LEFT JOINto find resources that should have overheads but don't.
- Resource/Overhead Cost Type: (Optional) Defaults to the costing method.
- Fast: Configuration data.
Q: Can a resource have multiple overheads? A: Yes, Labor might attract "Fringe", "Supervision", and "Occupancy" overheads. All will be listed.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics