CAC Standard Cost Update Submissions – 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 Standard Cost Update submissions, by Cost Update Date. Including the parameters used and the overall inventory and WIP adjustment values.

Parameters: Cost Update Date From: starting cost update date, based on standard cost submission history (required). Cost Update Date To: ending cost update date, based on standard cost submission history (required). From Cost Type: enter the cost type implemented by the Standard Cost Update into the Frozen costs (optional). 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 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_cost_update_submissions_rept.sql – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 28 Sep 2023 Douglas Volz Initial coding – | 1.1 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

Cost Update Date From, Cost Update Date To, From Cost Type, Organization Code, Operating Unit, Ledger

Oracle EBS Tables Used

mtl_category_sets_vl, mtl_categories_v, mtl_parameters, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, cst_cost_updates, cst_cost_types, mtl_system_items_vl, gl_code_combinations_kfv

Report Categories

Enginatics

CAC Last Standard Item Cost, CAC New Standard Item Costs, GL Account Distribution Analysis, INV Items, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), CAC Intercompany SO Price List vs. Item Cost Comparison, INV Material Transactions, CAC Recost Cost of Goods Sold

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 Example
Blitz Report™ XML Import CAC_Standard_Cost_Update_Submissions.xml
SQL Source CAC Standard Cost Update Submissions.sql
Full Report on Enginatics www.enginatics.com/reports/cac-standard-cost-update-submissions/

Case Study & Technical Analysis: CAC Standard Cost Update Submissions

Executive Summary

The CAC Standard Cost Update Submissions report is an audit trail for the Standard Costing process. It tracks the execution of the “Update Standard Cost” program, providing a history of when costs were updated, who ran the update, and what the financial impact was.

Business Challenge

Solution

This report queries the cost update history.

Technical Architecture

Parameters

Performance

FAQ

Q: Does this show the specific items updated? A: No, this is a Header level report. For item details, you would use the “Standard Cost Update Adjustment” report (standard Oracle).

© Enginatics GmbH