CAC Resource Costs – Oracle EBS SQL Report

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

Overview

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. – +=============================================================================+ – | – | Original Author: Douglas Volz (doug@volzconsulting.com) – | – | Program Name: xxx_resource_costs_rept.sql – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 18 Nov 2010 Douglas Volz Initial Coding – | 1.1 15 Dec 2010 Douglas Volz Final Coding – | 1.2 28 Dec 2010 Douglas Volz Removed condition to omit Orgs 108, 109, 110 – | and 331 as these may be used at any time – | 1.3 18 Nov 2015 Douglas Volz Removed organization restrictions – | 1.4 15 Nov 2016 Douglas Volz Added DFF for Resource_Type, changed – | cancatenated segments to separate columns. – | 1.5 18 Nov 2016 Douglas Volz Added Activity to this report – | 1.6 16 Feb 2017 Douglas Volz Added Creation_Date and Who Created – | 1.7 17 Feb 2017 Douglas Volz Add Resource_Description – | 1.8 18 Sep 2019 Douglas Volz Added last update by and last update date – | 1.9 27 Jan 2020 Douglas Volz Changed to multi-language views for the item – | master, inventory orgs and operating units. – | 1.10 21 Jul 2021 Douglas Volz Add Basis Type, UOM Code and changed Allow – | Costs and Std Rate to lookup codes. – | 1.11 11 Oct 2023 Douglas Volz Modified for invalid created by, invalid – | last updated by and invalid code_combination_id – | values, to ensure resources are reported. – | Removed tabs and added inventory org access controls. – | Reversed revision 1.4, added back concatentated – | account number values. – +=============================================================================+*/

Report Parameters

Cost Type, Include Non-Costed Resources, Organization Code, Operating Unit, Ledger

Oracle EBS Tables Used

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

Report Categories

Enginatics

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

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 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/

Case Study & Technical Analysis: CAC Resource Costs

Executive Summary

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.

Business Challenge

Solution

This report dumps the resource definition.

Technical Architecture

Parameters

Performance

FAQ

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.

© 2026 Enginatics