My Oracle Support Banner

Aid To Testing Purchasing Approval Rules Against an Employee (Doc ID 1409604.1)

Last updated on MAY 20, 2022

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.

Goal

This document provides code that allows Purchasing Approval Rules assigned to an Employee to be tested against a Purchasing Document without the need to submit the document for approval.

Please note:
1. This script does NOT test AME rules used in the approval of Purchase Requisitions or Purchase orders.
2. This script does NOT test if the Username of the employee has been end-dated.
   
   - The script will display the Start Date and any End Date of the FND User.

3. This script does NOT test if the Employee assigned to the selected Username has been end-dated.

   - The script uses the same View as the approval code - HR_EMPLOYEES_CURRENT_V - which *only* returns active employees.

4. This script does NOT approve any Purchasing document.

This script is not designed to work with Rel 11i as the Document Manager, which performs the authorization checks, was re written for Rel 12.

 

Disclaimer Notice:
The script provided by this document is for educational purposes only and is not supported by Oracle Global Customer Support.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.