CAC Shipping Network (Inter-Org) 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 inter-org shipping network. If the accounts are missing or invalid the account segments are shown as blank entries.

/* +=============================================================================+ – | 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_interorg_setup_accts_rept.sql – | – | Parameters: – | p_from_org_code – Specific from inventory organization you wish to report (optional) – | p_from_operating_unit – From 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 inter-org shipping network. If the – | accounts are missing or invalid the account segments are shown as blank entries. – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 24 Nov 2009 Douglas Volz Initial Coding – | 1.1 28 Oct 2010 Douglas Volz Added ledger parameter – | 1.2 25 Sep 2014 Douglas Volz Removed mfg_lookup for FOB point, was – | skipping direct transfers – | 1.3 07 Jan 2015 Douglas Volz Minor bug fixes – | 1.4 08 Oct 2015 Douglas Volz Modify for latest client’s COA – | 1.5 06 Oct 2016 Douglas Volz Modified for latest client’s COA – | 1.6 16 Jan 2017 Douglas Volz Added Internal Order Flag Required, – | Elemental Visibility Enabled and – | Profit in Inventory Account – | 1.7 21 Jan 2017 Douglas Volz Added Manual Receipt required for expenses flag – | 1.8 17 Jul 2018 Douglas Volz Modified chart of accounts for client – | 1.9 16 Oct 2018 Douglas Volz Retrofitted to Release 11i and added To-Org – | Operating Unit – | 1.10 18 Oct 2018 Douglas Volz Added InterOrg Transfer Code and Percentage – | 1.11 11 Jul 2019 Douglas Volz Changed to G/L short name, chg to Release 12 – | 1.12 17 Jan 2020 Douglas Volz Add Org Code and Operating Unit parameters. – | 1.13 20 Apr 2020 Douglas Volz Add outer join for gl code combinations, for – | invalid or missing accounts (CCIDs). – | 1.14 27 Apr 2020 Douglas Volz Changed to multi-language views for the – | inventory orgs and operating units. – | 1.15 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

From Org Code, From Operating Unit, From Ledger

Oracle EBS Tables Used

mtl_parameters, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, mtl_interorg_parameters, gl_code_combinations

Report Categories

Enginatics

CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Pending Cost Adjustment - No Currencies, CAC Inventory Pending Cost Adjustment, CAC Intransit Value (Real-Time), 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)

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 Network (Inter-Org) Accounts Setup 08-Jul-2022 195805.xlsx
Blitz Report™ XML Import CAC_Shipping_Network_Inter_Org_Accounts_Setup.xml
SQL Source CAC Shipping Network (Inter-Org) Accounts Setup.sql
Full Report on Enginatics www.enginatics.com/reports/cac-shipping-network-inter-org-accounts-setup/

Case Study & Technical Analysis: CAC Shipping Network (Inter-Org) Accounts Setup

Executive Summary

The CAC Shipping Network (Inter-Org) Accounts Setup report is a critical financial control report. It documents the configuration of the “Shipping Network”—the rules and accounts that govern inventory transfers between organizations. This setup determines how transfers happen (Direct vs. Intransit) and where the money goes.

Business Challenge

Solution

This report audits the mtl_interorg_parameters table.

Technical Architecture

Parameters

Performance

FAQ

Q: What is “FOB Point”? A: “Free On Board”. It determines ownership during transit. * FOB Shipment: Receiving Org owns it while on the truck. * FOB Receipt: Shipping Org owns it while on the truck. Q: Why are the accounts blank? A: If the transfer type is “Direct”, Intransit accounts are not required.

© Enginatics GmbH