PO Approval Hierarchy – 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

Purchasing approval hierarchy: for each employee, the approvers above them level by level, with each approver’s approval groups and document total limit for the selected document type.

The operating unit’s Use Approval Hierarchies option (Financials Options) decides the hierarchy: the position hierarchy, which defaults to the document type’s default approval hierarchy, or else the supervisor chain of the primary assignments. Both are read as of the As of Date. The approval workflow reads the position hierarchy from the copy built by the Fill Employee Hierarchy program, so run that program when routing differs from this report.

One row per employee, level, approver and approval group. Level 0 is the employee’s own approval authority. A position held by several people shows one row per holder, a vacant position shows the position without an approver. Employees at the top of the hierarchy appear only as approvers.

Approval Amount From is the highest document total limit below that level in the employee’s chain, so each approver row shows the amount band it approves. Template By Position shows the approval chain per initiator position instead of per employee.

Approval groups are those assigned to the approver’s position (position hierarchy) or job (supervisor hierarchy) for the document type in Approval Assignments. Document Total Limit is the amount limit of the group’s Document Total rule; account, item and location rules are listed by PO Approval Assignments with Show Approval Group Amounts.

Use the Approver parameter to list everyone a person approves for.

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

Operating Unit, Document Type, Hierarchy, HR Organization, Employee, Approver, As of Date, Maximum Levels

Oracle EBS Tables Used

hr_operating_units, financials_system_params_all, po_document_types_all_vl, per_position_structures, per_pos_structure_versions, per_pos_structure_elements, per_all_assignments_f, po_control_rules, po_control_functions, po_position_controls_all, po_control_groups_all, per_all_people_f, per_positions, per_jobs_vl, hr_all_organization_units_vl

Report Categories

Enginatics

PO Approval Assignments, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, PO Approval History, PER Position Hierarchy, PO Approval Groups Upload, FA Asset Book Details, AP Supplier 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 Approval Hierarchy 02-Nov-2026 020116.xlsx
Blitz Report™ XML Import PO_Approval_Hierarchy.xml
SQL Source PO Approval Hierarchy.sql
Full Report on Enginatics www.enginatics.com/reports/po-approval-hierarchy/

© Enginatics GmbH