CAC Resources by Department Setup – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Cost Accounting · all Cost Accounting reports

Overview

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. | – +=============================================================================+ – | – | Original Author: Douglas Volz (doug@volzconsulting.com) – | – | Program Name: xxx_resources_by_dept.sql – | – | Parameters: – | p_org_code – Specific inventory organization you wish to report (optional) – | p_operating_unit – Operating Unit you wish to report, leave blank for all – | operating units (optional) – | p_ledger – general ledger you wish to report, leave blank for all – | ledgers (optional) – | p_cost_type – Enter Pending or Frozen or AvgRates for the Cost Type.
– | Optional, defaults to your AvgRates or Frozen Cost Type, – | depending on your Costing Method. – | Description: – | Report to show which resources are assigned to which departments. – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 21 Jan 2017 Douglas Volz Initial Coding – | 1.1 20 Jan 2020 Douglas Volz Add operating unit and org code parameters. – | 1.2 20 Apr 2020 Douglas Volz Make Cost Type default work for all cost methods – | 1.3 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards. – +=============================================================================+*/

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

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

Oracle EBS Tables Used

cst_activities, mtl_parameters, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, cst_cost_types, bom_resources, cst_cost_elements, bom_department_resources, bom_departments, cst_resource_costs

Report Categories

Enginatics

CAC Item Cost & Routing, CAC WIP Account Detail, CAC Department Overhead Setup Errors, CAC Resources Associated with Overheads Setup, CAC Resource Costs, CAC Manufacturing Variance, CAC Department Overhead Setup, CAC WIP Resource Efficiency, CAC ICP PII WIP Material Usage Variance

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

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
SQL Source CAC Resources by Department Setup.sql
Full Report on Enginatics www.enginatics.com/reports/cac-resources-by-department-setup/

Case Study & Technical Analysis: CAC Resources by Department Setup

Executive Summary

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).

Business Challenge

Solution

This report lists the assignments.

Technical Architecture

Parameters

Performance

FAQ

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.

© Enginatics GmbH