AME Purchase Requisition Approval Error : Approval List Could not be Generated, Test Workbench Shows GET_SECURITY_PREDICATE_HELPER
Last updated on FEBRUARY 24, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms