| layout | default |
|---|---|
| title | CAC Resource Costs | Oracle EBS SQL Report |
| description | Report to show the resource and outside processing costs by organization and cost type. Parameters: Cost Type: enter the cost type you wish to report… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, CAC, Resource, Costs, cst_activities, cst_resource_costs, bom_resources |
| permalink | /CAC%20Resource%20Costs/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Report to show the resource and outside processing costs by organization and cost type.
Parameters: Cost Type: enter the cost type you wish to report, defaults to your Costing Method (mandatory). Include Non-Costed Resources: choose No to exclude non-costed resources, choose Yes to include them. You normally use non-costed resources for scheduling purposes (mandatory). 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 2006-2023 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.
| -- +=============================================================================+ |
|---|
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- +=============================================================================+*/ |
Cost Type, Include Non-Costed Resources, Organization Code, Operating Unit, Ledger
cst_activities, cst_resource_costs, bom_resources, mtl_system_items_vl, mtl_parameters, cst_cost_elements, cst_cost_types, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, mfg_lookups, gl_code_combinations_kfv, fnd_user, 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 Item Cost Break-Out by Activity, CAC Missing WIP Accounting Transactions, CAC Load More4Apps Buy Item Costs, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Resources by Department Setup, CAC Manufacturing Variance, 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 Resource Costs 12-Jul-2022 220258.xlsx |
| Blitz Report™ XML Import | CAC_Resource_Costs.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cac-resource-costs/ |
The CAC Resource Costs report is a master data management tool for Manufacturing Costing. It lists the setup of all Resources (Labor, Machine, Outside Processing) and their associated Standard Rates. This is the foundation of the "Value Added" portion of a product's standard cost.
- Cost Accuracy: If the "Assembly Labor" rate is outdated ($20/hr vs. actual $25/hr), every product made will be under-costed.
- Consistency: Ensuring that similar resources (e.g., "Forklift Driver") have consistent rates across different inventory organizations.
- Audit: Verifying that all active resources have a non-zero cost.
This report dumps the resource definition.
- Details: Resource Name, Unit of Measure (HR, EA, DOL), Activity (Run, Setup).
- Rates: The standard rate per unit.
- Type: Cost Element (Labor, Outside Processing, Overhead).
- Tables:
bom_resources,cst_resource_costs,cst_cost_types. - Logic: Joins the resource definition to its cost record for the specified Cost Type.
- Cost Type: (Mandatory) Usually "Frozen" or "AverageRates".
- Include Non-Costed Resources: (Mandatory) Toggle to show scheduling-only resources.
- Fast: Master data tables are small.
Q: What is "Outside Processing" (OSP)? A: A resource representing a service performed by a vendor (e.g., Plating). The "Rate" is the standard price we pay the vendor.
- 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