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 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.

Symptoms

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
or
1. Go to Test Workbench in Approvals Management Business Analyst responsibility, Run the Real Transaction Test

Cause

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