Skip to the content.

PO Cancelled Purchase Orders – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Purchasing · all Purchasing reports

Overview

Application: Purchasing Source: Cancelled Purchase Orders Report (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG

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

Show Order Lines, Operating Unit, Vendor From, Vendor To, Buyer Name, Cancelled Date From, Cancelled Date To, Creation Date From, Creation Date To

Oracle EBS Tables Used

po_headers_all, po_action_history, po_vendors, ap_supplier_sites_all, fnd_user, per_all_people_f, po_system_parameters_all, xxen_report_org_access, hr_all_organization_units_vl, fnd_lookup_values_vl, financials_system_params_all, po_lines_all, po_line_locations_all, mtl_categories_kfv, mtl_system_items_vl, po_releases_all

Report Categories

Enginatics

GL Account Analysis, GL Account Distribution Analysis, INV Items, PO Headers and Lines, GL Account Analysis (Drilldown) (with inventory and WIP), PO Purchase Requisitions with PO Details, AP Supplier Upload, AP Invoices and Lines, PO Purchasing Document Upload

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 PO Cancelled Purchase Orders 03-Mar-2023 034355.xlsx
Blitz Report™ XML Import PO_Cancelled_Purchase_Orders.xml
SQL Source PO Cancelled Purchase Orders.sql
Full Report on Enginatics www.enginatics.com/reports/po-cancelled-purchase-orders/

PO Cancelled Purchase Orders - Case Study

Executive Summary

The PO Cancelled Purchase Orders report provides Procurement Managers and Financial Controllers with critical visibility into cancelled spending commitments. By aggregating data on cancelled headers and lines, this report helps organizations analyze patterns in order cancellations, manage supplier relationships, and ensure that financial liabilities are properly de-obligated in the system.

Business Challenge

Cancelled orders, if not monitored, can lead to several business issues:

The Solution

The PO Cancelled Purchase Orders report offers a clear “Operational View” of the cancellation history.

Key Features:

Technical Architecture

The report queries the Purchasing tables, focusing on status flags and action history.

Primary Tables:

Logical Relationships: The report filters PO_HEADERS_ALL (and optionally PO_LINES_ALL) where the CANCEL_FLAG is set to ‘Y’. It joins to PO_VENDORS to retrieve supplier names and PER_ALL_PEOPLE_F to identify the buyer.

Parameters & Filtering

Key parameters allow for targeted analysis:

Performance & Optimization

Frequently Asked Questions

Q: Does this report include orders that were “Finally Closed”? A: “Finally Closed” and “Cancelled” are distinct statuses in Oracle EBS. This report specifically targets orders where the Cancel action was performed. Finally Closed orders are typically handled by the “PO Final Close” process.

Q: Can I see who cancelled the order? A: Yes, by linking to the PO_ACTION_HISTORY or checking the LAST_UPDATED_BY fields on the cancellation action, the report can identify the user responsible.

Q: Does it show the value of the cancelled funds? A: Yes, the report typically calculates the cancelled amount based on the quantity cancelled and the unit price, helping Finance understand the value of de-obligated funds.


© Enginatics GmbH