You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to extract a Report on Purchase Requisition and Purchasing Approval Rules

Received Response
edited Feb 22, 2024 11:47AM in Self Service Procurement 42 comments


The steps needed to produce a report of the approval rules that have been created in the system for Purchase Requisition and Purchasing related Approvals


Business Problem:

Customers often have a large number of complex approval rules configured on their system to enforce purchasing approval policies. For audit purpose, a common business ask is to provide a report on the approval policies prevailing across cost centers, track changes in approval policies over a period of time etc.

The attached document contains the steps to create a custom report based on SQL query using the Oracle BI Publisher reporting solution. The report will extract all requisition approval rules configured in system, the rule conditions and actions and the stages the rules are created in.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!