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™.

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

Report Parameters

Oracle EBS Tables Used

mtl_interorg_parameters, org_organization_definitions, mtl_parameters, mfg_lookups, fnd_lookups, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, mtl_intercompany_parameters, hr_organization_units, po_vendors, po_vendor_sites_all, hz_parties, hz_cust_accounts, ra_cust_trx_types_all, hz_cust_site_uses_all, qp_list_headers_tl

Report Categories

Enginatics

CAC Material Account Summary, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC ICP PII Material Account Summary, CAC Inventory Out-of-Balance, CAC Deferred COGS Out-of-Balance, CAC Intransit Value (Real-Time), CAC Shipping Network (Inter-Org) Accounts Setup, CAC Intercompany SO Shipping Transaction vs. Invoice Price

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 Shipping Networks Missing Interco OU Relationships 08-Jul-2022 200126.xlsx
Blitz Report™ XML Import CAC_Shipping_Networks_Missing_Interco_OU_Relationships.xml
Full SQL 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.

© 2026 Enginatics