CAC Receiving Activity Summary – 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

Especially for companies who do not use separate inspection receipt processes, this report nets the purchase order receipts into receiving against the deliveries into stock and WIP outside processing (OSP), using the Subledger Accounting entries on the organization’s receiving account for the entered transaction date range.

Each row is one subledger journal line on the receiving account, with the receiving transaction details shown in the Receiving Transactions form. With Unbalanced Distributions Only set to Yes, only PO distributions whose net amount per period, organization and receiving account is not zero are listed, so receipts and deliveries that offset each other drop out.

Quantity and UOM are the receiving transaction’s quantity and unit of measure. A receipt or return against several PO distributions shows each distribution’s share of the quantity.

Differences may be due to the initial receipt occurring in the prior month, not running Create Accounting in the current month, the goods never delivered into stock or OSP, or the delivery not processed by Create Accounting.

Template Summary by PO Distribution sums the amount per PO distribution and account.

Parameters:

Transaction Date From: enter the starting transaction date (mandatory). Defaults to the current period starting date. Transaction Date To: enter the ending transaction date (mandatory). Defaults to the current period ending date. Organization Code: enter the specific inventory organization(s) you wish to report (optional). Defaults to your session’s organization code. Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional).

/* +=============================================================================+ – | Copyright 2010 - 2024 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_rcv_activity_rept.sql – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 6 Jan 2010 Douglas Volz Initial Coding – | 1.1 05 Apr 2010 Douglas Volz Added PO number, PO Distribution id to query – | 1.2 25 Oct 2017 Douglas Volz Now use the receiving parameter Receiving ccid – | and added transaction source. – | 1.3 13 Mar 2018 Douglas Volz Added Ledger parameter – | 1.4 08 Jul 2022 Douglas Volz Multi-language tables for item master. – | 1.5 24 Jun 2024 Douglas Volz Remove tabs, reinstall parameters and inventory org access controls. – | 1.6 16 Oct 2026 Andy Haack One row per subledger journal line with the receiving transaction columns. – | 1.7 21 Oct 2026 Mrugesh Poojary Quantity and UOM columns. – +=============================================================================+*/

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

Transaction Date From, Transaction Date To, Organization Code, Operating Unit, Ledger, Unbalanced Distributions Only

Oracle EBS Tables Used

ap_suppliers, wip_entities, gl_daily_conversion_types, wms_license_plate_numbers, per_all_people_f, mtl_parameters, rcv_parameters, rcv_receiving_sub_ledger, rcv_accounting_events, rcv_transactions, xla_distribution_links, xla_ae_lines, xla_ae_headers, wip_transaction_accounts, wip_transactions, mtl_transaction_accounts, mtl_material_transactions, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, xxen_report_org_access, rcv_shipment_headers, rcv_shipment_lines, po_distributions_all, po_headers_all, po_lines_all, po_line_locations_all, mtl_system_items_vl, gl_code_combinations_kfv

Report Categories

Enginatics, R12 only

GL Account Distribution Analysis, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), INV Items, PO Headers and Lines, AP Invoices and Lines, CAC Purchase Price Variance, INV Item Upload, PO Purchase Price Variance

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 Receiving Activity Summary 16-Oct-2026 211251.xlsx
Blitz Report™ XML Import CAC_Receiving_Activity_Summary.xml
SQL Source CAC Receiving Activity Summary.sql
Full Report on Enginatics www.enginatics.com/reports/cac-receiving-activity-summary/

Case Study & Technical Analysis: CAC Receiving Activity Summary

Executive Summary

The CAC Receiving Activity Summary report analyzes the operational flow within the Receiving Dock. It compares “Receipts” (Goods arriving) against “Deliveries” (Goods moving to Stock or WIP). The net difference represents goods sitting in “Receiving Inspection”—physically on the dock but not yet available for use.

Business Challenge

Solution

This report performs a “Netting” logic.

Technical Architecture

Parameters

Performance

FAQ

Q: Does this match the GL? A: It should. The “Remaining in Receiving” value should equal the balance of the Receiving Inspection account for that period.

© Enginatics GmbH