CAC Shipping Networks Missing Interco OU Relationships – 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 missing inventory intercompany operating unit relationships. This report has no parameters.

/* +=============================================================================+ – | Copyright 2009 - 2020 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_missing_interco_setups_for_shipping_networks_v1.sql – | – | Parameters: – | None – | – | Description: – | Report to show the missing inventory intercompany operating unit relationships. – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 16 Oct 2018 Douglas Volz Initial Coding – | 1.1 11 Apr 2019 Douglas Volz Revert to Release 12 – | 1.2 29 Apr 2020 Douglas Volz Changed to multi-language views for the – | inventory orgs and operating units. – | 1.3 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

None

Oracle EBS Tables Used

mtl_interorg_parameters, mtl_parameters, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, mtl_intercompany_parameters

Report Categories

Enginatics

CAC Interface Error Summary, CAC Intransit Value (Real-Time), CAC Shipping Network (Inter-Org) Accounts Setup, CAC Inventory Accounts Setup, CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory Lot and Locator OPM Value (Period-End), CAC Inventory and Intransit Value (Period-End), CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End) - Discrete/OPM

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 Shipping Networks Missing Interco OU Relationships 08-Jul-2022 200126.xlsx
Blitz Report™ XML Import CAC_Shipping_Networks_Missing_Interco_OU_Relationships.xml
SQL Source CAC Shipping Networks Missing Interco OU Relationships.sql
Full Report on Enginatics www.enginatics.com/reports/cac-shipping-networks-missing-interco-ou-relationships/

Case Study & Technical Analysis: CAC Shipping Networks Missing Interco OU Relationships

Executive Summary

The CAC Shipping Networks Missing Interco OU Relationships report is a specific configuration validator. In Oracle EBS, defining a “Shipping Network” (physical path) between two organizations is not enough for financial transactions. You must also define the “Intercompany Relations” (financial path) between their respective Operating Units. This report finds the gaps.

Business Challenge

Solution

This report compares two setups.

Technical Architecture

Parameters

Performance

FAQ

Q: Do I need this for Intracompany (same OU) transfers? A: No, transfers within the same Operating Unit do not require Intercompany Relations. This report filters for cross-OU networks.

© Enginatics GmbH