CAC Intercompany Relationship Setup – Oracle EBS SQL Report

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

Overview

Report to show accounts used for the intercompany parameters and relationships across operating units.

/* +=============================================================================+ – | Copyright 2018 - 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_interco_parameters_rept.sql – | – | Parameters: – | none – | – | Description: – | Report to show accounts used for the intercompany parameters and relationships – | across operating units. – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 16 Oct 2018 Douglas Volz Initial Coding, based on mtl_intercompany_parameters_v – | 1.1 7 Mar 2020 Douglas Volz Add Advanced Accounting Option based on view – | mtl_transaction_flows_v. – | 1.2 27 Apr 2020 Douglas Volz Changed to multi-language views for the – | inventory orgs and operating units. – +=============================================================================+*/

Report Parameters

Oracle EBS Tables Used

mtl_intercompany_parameters, hr_all_organization_units_vl, mtl_transaction_flow_headers, mtl_transaction_flow_lines, mtl_parameters, fnd_lookups, mfg_lookups, 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, gl_code_combinations_kfv

Report Categories

Enginatics

CAC AP Accrual IR ISO Match Analysis, INV Intercompany Invoice Reconciliation 11i, CAC Intercompany SO Price List vs. Item Cost Comparison, CAC Interface Error Summary, PPF_WP3_OM_DETAILS, ONT Orders

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 Intercompany Relationship Setup 23-Jun-2022 155938.xlsx
Blitz Report™ XML Import CAC_Intercompany_Relationship_Setup.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-intercompany-relationship-setup/

Case Study & Technical Analysis: CAC Intercompany Relationship Setup

Executive Summary

The CAC Intercompany Relationship Setup report provides a comprehensive visualization of the intercompany accounting configuration within Oracle E-Business Suite. It details the complex web of relationships, transaction flows, and account mappings between different operating units and inventory organizations. This report is essential for Finance and Supply Chain teams to verify that intercompany transactions will be accounted for correctly, ensuring accurate financial consolidation and reconciliation.

Business Challenge

Intercompany transactions (e.g., shipping from one legal entity to another) require precise setup in Oracle Inventory and Intercompany Invoicing.

Solution

This report bridges the visibility gap by extracting and consolidating intercompany setup data.

Technical Architecture

The SQL logic navigates the complex schema of Oracle Intercompany setup:

Parameters

Performance

FAQ

Q: Does this report show the actual intercompany transactions? A: No, this is a setup validation report. It shows how the system is configured to handle transactions, not the transactions themselves.

Q: Why are some accounts missing in the output? A: If accounts are missing, it indicates a gap in the Oracle setup. This report highlights those gaps so they can be fixed before transactions occur.

Q: Does it cover Advanced Accounting (Transaction Flows)? A: Yes, the report includes logic to display Advanced Accounting options derived from mtl_transaction_flows_v.

© 2026 Enginatics