My Oracle Support Banner

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:

X Error
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:

X Error
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 :

ame_engine.fetchAttributeValues 1 "Attribute ::: PO_COST_CENTER(10368),error:ORA-20001: APP-FND-00222: Encountered an error while getting the ORACLE user account for your concurrent request. Contact your system administrator."

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

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