CAC Item vs. Component Include in Rollup Controls – Oracle EBS SQL Report

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

Overview

Use this report to find items where the item master default setting for include in rollup does not match the BOM component include in rollup setting. This report includes items which are available for costing, where the inventory costing enabled flag is Yes. And excludes inactive items. (This report was removed from the Cost vs. Planning Item Control Report, for performance reasons.)

/* +=============================================================================+ – | Copyright 2021 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_item_include_in_bom_ctrls_repts.sql – | – | Parameters: – | – | p_cost_type – Desired cost type, mandatory – | p_assignment_set – The assignment set you wish to report (optional) – | p_item_number – Specific item number, to get all values enter a – | null value or blank value – | 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) – | – | Description: – | Use the below SQL scripts to find items where the item default include in – | rollup does not match the BOM component include in rollup. (Removed from – | the Cost vs. Planning Item Control Report, for performance reasons.) – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 07 May 2021 Douglas Volz Initial Coding, based on the Cost vs. – | Planning Item Control Report, version 33. – +=============================================================================+*/

Report Parameters

Cost Type, Category Set 1, Category Set 2, Category Set 3, Assignment Set, Item Number, Organization Code, Operating Unit, Ledger

Oracle EBS Tables Used

fnd_lookups, bom_structures_b, bom_operational_routings, mrp_sr_receipt_org, mrp_sr_source_org, mrp_sourcing_rules, mrp_sr_assignments, mrp_assignment_sets, mtl_parameters, mtl_system_items_vl, mtl_item_status_vl, mtl_units_of_measure_vl, cst_item_costs, cst_cost_types, org_access_view, bom_components_b, mfg_lookups, fnd_common_lookups, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, 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 Items, CAC New Standard Item Costs, CAC User-Defined and Rolled Up Costs, CAC Cost vs. Planning Item Controls, CAC Inventory Organization Summary, CAC Calculate ICP PII Item Costs by Where Used, CAC Intercompany SO Price List vs. Item Cost Comparison, CAC Calculate ICP PII Item Costs

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 Item vs. Component Include in Rollup Controls 24-Jun-2022 050039.xlsx
Blitz Report™ XML Import CAC_Item_vs_Component_Include_in_Rollup_Controls.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-item-vs-component-include-in-rollup-controls/

Case Study & Technical Analysis: CAC Item vs. Component Include in Rollup Controls

Executive Summary

The CAC Item vs. Component Include in Rollup Controls report is a specialized diagnostic tool for the Cost Rollup process. It identifies a specific configuration conflict: items where the “Include in Rollup” flag on the Item Master contradicts the settings on the Bill of Materials (BOM). This mismatch is a common cause of incorrect standard costs.

Business Challenge

The Cost Rollup process relies on clear instructions: “Should I calculate the cost of this sub-assembly?”

Solution

This report finds the contradictions.

Technical Architecture

The report joins the Item Master to the BOM structure:

Parameters

Performance

FAQ

Q: Which setting wins? A: The Cost Rollup generally respects the Component flag when rolling up a specific structure, but the Item flag controls whether the item itself is selected for rollup. A mismatch creates ambiguity and unexpected results.

Q: Should they always match? A: In 99% of cases, yes. If an item is a phantom or a sub-assembly that needs costing, both flags should be consistent.

Q: Does this fix the data? A: No, it is a reporting tool. You must manually update the Item Master or the BOM to resolve the conflict.

© 2026 Enginatics