AME Purchase Requisition Approval Error : Approval List Could not be Generated, Test Workbench Shows GET_SECURITY_PREDICATE_HELPER
(Doc ID 1544417.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Purchasing - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
When attempting to submit for approval a requisition with the Approval Management Engine (AME), the following error occurs and the requisitions cannot be approved.
From the iProcurement responsibility, in the Checkout: Approvals and Notes page, there is the following error message:
Approval List could not be generated. Please contact your System Administrator to review AME rules setup
Test Workbench for the Transaction Id corresponding to the po_requisition_header_id value shows the following error message:
An unexpected situation occurred while executing routine FND_DATA_SECURITY.GET_SECURITY_PREDICATE_HELPER. The cause was: The parameter p_object_name can not be 'GLOBAL'.
The fnd_log_messages output shows :
The issue can be reproduced with the following steps:
1. Create and submit for approval a requisition in the iProcurement responsibility
1. Go to Test Workbench in Approvals Management Business Analyst responsibility, Run the Real Transaction Test
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