| layout | default |
|---|---|
| title | CAC Resources by Department Setup | Oracle EBS SQL Report |
| description | Report to show which resources are assigned to which departments. With the respective resource rates as well. /… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, CAC, Resources, Department, Setup, cst_activities, bom_departments, bom_resources |
| permalink | /CAC%20Resources%20by%20Department%20Setup/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Report to show which resources are assigned to which departments. With the respective resource rates as well.
/* +=============================================================================+ -- | Copyright 2016 - 2022 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_activities, bom_departments, bom_resources, bom_department_resources, cst_resource_costs, cst_cost_types, cst_cost_elements, mtl_parameters, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, mfg_lookups, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, mo_glob_org_access_tmp, dual, org_access_view
CAC Item Cost & Routing, CAC Manufacturing Variance, CAC Resources Associated with Overheads Setup, CAC WIP Account Detail, CAC ICP PII WIP Material Usage Variance, CAC Department Overhead Setup, CAC Department Overhead Setup Errors, CAC Resource Costs, CAC WIP Resource Efficiency
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 by Department Setup 08-Jul-2022 195451.xlsx |
| Blitz Report™ XML Import | CAC_Resources_by_Department_Setup.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cac-resources-by-department-setup/ |
The CAC Resources by Department Setup report validates the manufacturing topology. It shows which Resources are available in which Departments. This setup controls both Scheduling (Capacity Planning) and Costing (Departmental Rates).
- Routing Errors: You cannot add a Resource to a Routing Operation if that Resource is not assigned to the Department.
- Capacity Planning: "Do we have enough 'Welding' capacity in the 'Fabrication' department?"
- Costing: Some overheads are Department-specific. This setup links the resource to the department context.
This report lists the assignments.
- Hierarchy:
Department->Resource. - Capacity: Shows "Capacity Units" (e.g., 2 machines) and "Available 24 Hours" flags.
- Costing: Shows the resource rate (for convenience).
- Tables:
bom_departments,bom_department_resources,bom_resources. - Logic: Standard join of the BOM setup tables.
- Organization Code: (Optional) Filter by plant.
- Fast: Master data.
Q: Can a resource be in multiple departments? A: Yes, "General Labor" might be assigned to every department. "Specialized CNC" might be in only one.
- 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