Aid To Return the Approval Rules Assigned To A Purchasing Document Type And Subtype.
Last updated on JUNE 01, 2016
Applies to:Oracle Purchasing - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
The aim of this document is to provide SQL that will return the purchasing approval rules, their groups and the Job and/or position that have been assigned those rules for a given Purchasing document type and subtype.
For each Purchasing Document that it subjected to Purchasing Approval Rules, the application uses the following Document Type and Document Subtype:
|Document Type||Document Subtype|
|REQUISITION||INTERNAL or PURCHASE|
|PO||STANDARD or PLANNED|
|PA||CONTRACT or BLANKET|
|Release||SCHEDULED or BLANKET|
Approval Rules can be applied to each document type/subtype and only when those rules are meet will the document be approved:
|Rule Object||Required||DB Object Value|
|Item Category Range||Optional||ITEM_CATEGORY_RANGE|
An Approval Group contains the rules (Purchasing's Approval Groups form - POXSTDCG)
The Approval Group is then assigned to the required documents that a Job (and Position if Positional Hierarchies are used) is expected to approve (Purchasing's Assign Approval Groups form - POXSTDPC)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms