Oracle EBS Purchasing Reports

20 ready-to-run SQL reports for Oracle E-Business Suite Purchasing, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Purchasing tables in these reports are po_headers_all, mtl_system_items_vl, rcv_transactions, ap_suppliers, po_releases_all, hr_all_organization_units_vl.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Purchasing SQL Reports

Report Description
PO Approval Assignments Active PO document approval group assignments with HR jobs or positions
PO Approval Groups PO approval groups and approval rules e.g. amount limits or account ranges
PO Approval History Approval and action history of purchase orders, releases, agreements and requisitions: one row per entry of the document’s action history (submit, forward…
PO Approved Supplier List Approved supplier list and attribute details such as source documents, supplier scheduling, planning constraints and inventory attributes.
PO Cancelled Purchase Orders Application: Purchasing Source: Cancelled Purchase Orders Report (XML) Short Name: POXPOCANXML DB package: POPOXPOCANXMLPPKG
PO Cancelled Requisitions Application: Purchasing Source: Cancelled Requisition Report (XML) Short Name: POXRQCRQXML DB package: POPOXRQCRQXMLPPKG
PO Document Types PO document types setup
PO Headers PO headers or releases with corresponding invoices and their payment status. Example: To show all POs or releases which have an invoice but no receiving TRX…
PO Headers and Lines PO headers, lines, receiving transactions and corresponding AP invoices When India Localization is installed, the following GST columns are also included: GST…
PO Internal Requisitions and Sales Orders Report to display internal sales orders and requisition numbers, with aging dates and other useful information.
PO Internal Requisitions/Deliveries Discrepancy Application: Purchasing Description: Internal Requisitions/Deliveries Discrepancy Report Source: Internal Requisitions/Deliveries Discrepancy Report (XML)…
PO Invoice Price Variance Imported Oracle standard Invoice Price Variance report Application: Purchasing Source: Invoice Price Variance Report Short Name: POXRCIPV
PO Printed Planning Schedule Migration of the Oracle standard concurrent program Printed Planning Schedule (XML) (CHVPRSCHXML) from Supplier Scheduling. Shows, for each confirmed…
PO Procure to Pay Tracker One row per purchase order shipment, and per requisition line not yet on a purchase order, with the date of each step from requisition to payment and the…
PO Purchase Price Variance Imported Oracle standard Purchase Price Variance report Source: Purchase Price Variance Report (XML) Short Name: POXRCPPVXML DB package: POPOXRCPPVXMLPPKG
PO Purchase Requisitions with PO Details Purchase Requisitions Status with PO Details Report. Lists purchase requisition headers, lines and distributions together with the purchase order they were…
PO Receipts/Deliveries Discrepancy PO Receipts/Deliveries Discrepancy highlights, at purchase order line and release level, differences between the quantities and amounts received into receiving…
PO Receiving Transactions Receiving transactions register: one row per receiving transaction (receive, accept, reject, transfer, deliver, return to supplier or receiving, correction)…
PO Supplier Scheduling On-Time Delivery 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…
PO Vendor Service Performance Analysis Imported from BI Publisher Application: Purchasing Source: Vendor Service Performance Analysis Report (XML) Short Name: POXSERPRXML DB package…

← All Oracle EBS modules

© Enginatics GmbH