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

Summary

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

Content

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.