CAC Intercompany SO Shipping Transaction vs. Invoice Price – Oracle EBS SQL Report

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

Overview

Report to compare the transaction item cost from the selling internal org to the invoice sales price the selling internal organization is charging the internal receiving organization.

/* +=============================================================================+ – | Copyright 2017 - 2022 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_verify_so_price_vs_cost_txn.sql – | – | Parameters: – | p_trx_date_from – starting shipping transaction date, mandatory – | p_trx_date_to – ending shipping transaction date, mandatory – | – | Description: – | Report to compare the transaction item cost from the selling internal org – | to the invoice sales price the selling internal organization is charging the – | receiving organization. – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 01 May 2017 Douglas Volz Initial Coding – | 1.1 03 Sep 2019 Douglas Volz Add Ledger, Operating Unit, Item Type, Status – | and item categories for cost and inventory. – | 1.2 27 Jan 2020 Douglas Volz Added Ledger, Operating Unit and Org Code – | parameters. – | 1.3 09 Jul 2022 Douglas Volz Changes for multi-language lookup values. – +=============================================================================+*/

Report Parameters

Transaction Date From, Transaction Date To, Category Set 1, Category Set 2, Category Set 3, Ledger

Oracle EBS Tables Used

ra_customer_trx_lines_all, mtl_material_transactions, mtl_transaction_types, mtl_system_items_vl, mtl_item_status_vl, mtl_units_of_measure_vl, mtl_parameters, oe_order_headers_all, oe_order_lines_all, fnd_common_lookups, mfg_lookups, fnd_lookups, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v

Report Categories

Enginatics

CAC Internal Order Shipment Margin, CAC Deferred COGS Out-of-Balance, GL Account Analysis (Distributions), GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, GL Account Analysis

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 SO Shipping Transaction vs. Invoice Price 10-Jul-2022 224012.xlsx
Blitz Report™ XML Import CAC_Intercompany_SO_Shipping_Transaction_vs_Invoice_Price.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-intercompany-so-shipping-transaction-vs-invoice-price/

Case Study & Technical Analysis: CAC Intercompany SO Shipping Transaction vs. Invoice Price

Executive Summary

The CAC Intercompany SO Shipping Transaction vs. Invoice Price report is a transactional audit tool that verifies the financial accuracy of intercompany shipments. It compares the cost of the item at the time of shipment (from the selling organization) against the actual invoice price charged to the receiving organization. This report is vital for detecting revenue leakage and ensuring that intercompany billing aligns with transfer pricing policies.

Business Challenge

In day-to-day operations, discrepancies can arise between the expected transfer price and the actual invoiced amount.

Solution

This report provides a line-level reconciliation of shipping transactions.

Technical Architecture

The report bridges the gap between Supply Chain and Finance:

Parameters

Performance

FAQ

Q: Why would the invoice price differ from the price list? A: Manual overrides on the sales order, modifiers/discounts applied inadvertently, or price list changes between order booking and invoicing can cause discrepancies.

Q: Does this report show the receiving side? A: This report focuses on the selling side (Shipment and AR Invoice). The receiving side (Receipt and AP Invoice) is typically handled by separate reconciliation reports.

Q: Can I use this for external customers? A: While the logic is similar, this report is tailored for Intercompany flows where the relationship between Cost and Price is strictly governed by policy.

© 2026 Enginatics