PO Supplier Scheduling On-Time Delivery – Oracle EBS SQL Report

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

Overview

Supplier on-time delivery (OTD) based on the Oracle Supplier Scheduling (CHV) module instead of the purchase order form. For each firm scheduled release the report compares the scheduling-module requested delivery date against the actual goods receipt date and reports the delivery delay, ordered vs received quantity, and a partial-delivery flag. Designed for environments where the blanket PO holds only a skeleton (with placeholder dates) and the real call-off dates arrive via EDI into Supplier Scheduling. First-pass draft - see version comments for open scoping items.

Report Parameters

Operating Unit, Supplier, Requested Date From, Requested Date To, Received Date From, Received Date To, On Time Tolerance Days

Oracle EBS Tables Used

per_all_people_f, rcv_transactions, rcv_shipment_headers, rcv_shipment_lines, chv_item_orders, chv_schedule_headers, po_line_locations_all, po_lines_all, po_headers_all, po_vendors, po_vendor_sites_all, mtl_system_items_b_kfv, mtl_parameters, hr_locations_all, hr_all_organization_units_vl, mo_glob_org_access_tmp, dual

Report Categories

Enginatics

PO Printed Planning Schedule, AP Invoices and Lines, GL Account Distribution Analysis, CAC Receiving Value (Period-End), 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 PO Supplier Scheduling On-Time Delivery 01-Jun-2026 020909.xlsx
Blitz Report™ XML Import PO_Supplier_Scheduling_On_Time_Delivery.xml
Full SQL on Enginatics www.enginatics.com/reports/po-supplier-scheduling-on-time-delivery/

© 2026 Enginatics