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™. Oracle EBS module: Cost Accounting · all Cost Accounting reports

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 – | 1.2 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

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

Oracle EBS Tables Used

mtl_parameters, cst_item_costs, cst_cost_types

Report Categories

Enginatics

INV Transaction Historical Summary, CAC PO Price vs. Costing Method Comparison, 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, BOM Resource Upload

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 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
SQL Source CAC Number of Item Costs by Cost Type.sql
Full Report 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.

© Enginatics GmbH