CAC Standard Cost Update Submissions – Oracle EBS SQL Report

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

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 – +=============================================================================+*/

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, cst_cost_updates, cst_cost_types, mtl_system_items_vl, mtl_parameters, org_access_view, mfg_lookups, fnd_user, gl_code_combinations_kfv, gl_ledgers, hr_organization_information, hr_all_organization_units_vl, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, mo_glob_org_access_tmp, dual

Report Categories

Enginatics

CAC Last Standard Item Cost, CAC New Standard Item Costs, CAC ICP PII Inventory Pending Cost Adjustment, CAC Intercompany SO Price List vs. Item Cost Comparison, CAC Deferred COGS Out-of-Balance, CAC Inventory Pending Cost Adjustment

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 None
Blitz Report™ XML Import CAC_Standard_Cost_Update_Submissions.xml
Full SQL 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).

© 2026 Enginatics