CAC Subinventory Accounts Setup – 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 accounts used for the subinventories; these valuation and expense accounts are used with Standard Costing.

/* +=============================================================================+ – | Copyright 2009 - 22 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_subinv_setup_accts_rept.sql – | – | Parameters: – | 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: – | Report to show accounts used for the subinventories – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 24 Nov 2009 Douglas Volz Initial Coding – | 1.1 28 Mar 2011 Douglas Volz Minor column heading changes – | 1.2 30 Mar 2011 Douglas Volz Minor column heading changes for Inv Asset, – | added quantity tracked and disable date – | columns – | 1.3 23 Dec 2014 Douglas Volz Added DFFs for “Use Item Type Accounts”. – | For OPM orgs, the ICP valuation reports use – | this to indicate if the Item Type accounts – | or the subinventory valuation accounts are – | displayed on the report. – | 1.4 07 Oct 2015 Douglas Volz Removed above DFFs for “Use Item Type Accounts”, – | changed COA to match new client. Also added – | Cost Group Name and accounts. Replaced OOD – | with mtl_parameters and mp.organization_name with – | haou.name. And removed prior client’s organization – | restrictions.
– | 1.5 11 Nov 2016 Douglas Volz Modified chart of accounts for client – | 1.6 28 Mar 2017 Douglas Volz Added Creation Date, Last Update Date, Created – | By, Last Updated By
– | 1.7 02 Feb 2020 Douglas Volz Added Operating Unit and Org Code Parameters – | and added outer join to gcc.code_combinations_id – | 1.8 29 Apr 2020 Douglas Volz Changed to multi-language views for the item – | master, inventory orgs and operating units. – | 1.9 10 Jul 2022 Douglas Volz Account Type column now uses a lookup code. – | 1.10 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

Organization Code, Operating Unit, Ledger

Oracle EBS Tables Used

cst_cost_groups, mtl_parameters, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, mtl_secondary_inventories, cst_cost_group_accounts, gl_code_combinations

Report Categories

Enginatics

CAC Category Accounts Setup, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Pending Cost Adjustment, CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory and Intransit Value (Period-End), CAC Inventory Out-of-Balance, CAC ICP PII Inventory and Intransit Value (Period-End)

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 Subinventory Accounts Setup 10-Jul-2022 111226.xlsx
Blitz Report™ XML Import CAC_Subinventory_Accounts_Setup.xml
SQL Source CAC Subinventory Accounts Setup.sql
Full Report on Enginatics www.enginatics.com/reports/cac-subinventory-accounts-setup/

Case Study & Technical Analysis: CAC Subinventory Accounts Setup

Executive Summary

The CAC Subinventory Accounts Setup report is a configuration audit tool for Inventory Valuation. In Oracle EBS, you can track inventory value at the Organization level or the Subinventory level. If using Subinventory-level tracking, this report validates that the GL accounts for each subinventory are defined correctly.

Business Challenge

Solution

This report lists the account mapping.

Technical Architecture

Parameters

Performance

FAQ

Q: What happens if the accounts are blank? A: If the subinventory accounts are blank, the system defaults to the Organization-level accounts defined in mtl_parameters.

© Enginatics GmbH