PO Receipts/Deliveries Discrepancy – Oracle EBS SQL Report

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

Overview

PO Receipts/Deliveries Discrepancy highlights, at purchase order line and release level, differences between the quantities and amounts received into receiving (transaction type RECEIVE) and delivered to their final destination (DELIVER), including the impact of any CORRECT transactions applied to either side.

Quantity Received and Quantity Delivered show the original transaction quantities, Quantity Corrected Receipt and Quantity Corrected Delivery the net correction impact, and Total Quantity Received and Total Quantity Delivered the corrected totals. Quantity Variance and Cost Variance compare the corrected totals, with amounts valued at the purchase price of each receiving transaction.

Return to Vendor and Return to Receiving quantities (net of their corrections) are shown for reference but are not netted into the variance columns.

Provide a Last Receipt Date range (required): the report shows purchase order lines that had a receipt within that range, and for each it nets ALL of the line’s receiving transactions to date, so the variance reflects the current outstanding received-vs-delivered position, not just activity in the window. Narrow the range (and/or add a PO, Supplier or Item filter) to keep large organizations fast.

By default the report shows discrepancy rows only (quantity or cost variance different from zero). Set parameter Discrepancies Only to No to list all purchase order receiving activity for the selected lines.

Report Parameters

Operating Unit, Organization Code, Supplier, PO Number, Item, Last Receipt Date From, Last Receipt Date To, Discrepancies Only

Oracle EBS Tables Used

po_line_locations_all, rcv_transactions, rcv_shipment_headers, po_headers_all, po_releases_all, po_lines_all, ap_suppliers, ap_supplier_sites_all, mtl_system_items_vl, mtl_parameters, hr_operating_units, org_access_view, mo_glob_org_access_tmp, dual

Report Categories

Enginatics

PO Headers and Lines, AP Invoices with PO, Intercompany and SLA Details, GL Account Distribution Analysis, PO Purchase Requisitions with PO Details, AP Invoices and Lines

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
Blitz Report™ XML Import PO_Receipts_Deliveries_Discrepancy.xml
Full SQL on Enginatics www.enginatics.com/reports/po-receipts-deliveries-discrepancy/

© 2026 Enginatics