CAC Number of Item Costs by Cost Type – Oracle EBS SQL Report

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

Overview

Report to show the count of item costs by cost type. Use this report after you copy from one cost type to another, to ensure all rows have been copied over.

/* +=============================================================================+ – | Copyright 2017 - 2019 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_count_costs_by_cost_type.sql – | – | Parameters: – | p_from_cost_type – The cost type you copied from, mandatory – | p_to_cost_type – The cost type you copied to, mandatory – | p_from_org_code – The inventory organization you copied from, if
– | enter a blank or null value you get all organizations – | p_to_org_code – The inventory organization you copied to, if
– | enter a blank or null value you get all organizations – | – | Description: – | Report to show the count of item costs by cost type. Use this report after – | you copy from one cost type to another, to ensure all rows have been copied over. – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 04 May 2017 Douglas Volz Initial Coding – | 1.1 31 Aug 2019 Douglas Volz Added to and from cost types and org codes – +=============================================================================+*/

Report Parameters

From Cost Type, To Cost Type, From Org Code, To Org Code

Oracle EBS Tables Used

cst_item_costs, mtl_parameters, cst_cost_types

Report Categories

Enginatics

INV Transaction Historical Summary, CST Item Standard Cost Upload, CAC Missing Material Accounting Transactions, CAC Missing WIP Accounting Transactions, CST Detailed Item Cost, CAC Resource Costs, CAC Inventory Pending Cost Adjustment - No Currencies, CAC Inventory Lot and Locator OPM Value (Period-End), CAC Internal Order Shipment Margin

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 Number of Item Costs by Cost Type 07-Jul-2022 152510.xlsx
Blitz Report™ XML Import CAC_Number_of_Item_Costs_by_Cost_Type.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-number-of-item-costs-by-cost-type/

Case Study & Technical Analysis: CAC Number of Item Costs by Cost Type

Executive Summary

The CAC Number of Item Costs by Cost Type report is a simple but vital utility for Cost Accountants. It provides a count of how many items exist in one Cost Type versus another. This is primarily used during the “Cost Copy” process to verify that the copy was successful and complete.

Business Challenge

Solution

This report provides a side-by-side count.

Technical Architecture

Parameters

Performance

FAQ

Q: Why would the counts differ? A: The “Cost Copy” program has options to “Copy Only Based on Rollup” or “Copy Only Buy Items”. If you used these filters, the target count will be lower. Also, if an item already exists in the target, it’s an update, not an insert, so the count might not change.

© 2026 Enginatics