AME Error Message Generating Approvers List In iProcurement (Doc ID 1275520.1)

Last updated on JANUARY 27, 2016

Applies to:

Oracle iProcurement - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 with Procurement Rollup Patch 11 (<Patch 8555411>) and ATG Rollup 7, when attempting to add another approver in iProcurement checkout on the Checkout: Review Approver List page(ReqApprListPG), an error is generated.  Reset Approval List also does not work.


Error:

Application presents this error to users:

X Error
Approval List could not be generated. Please contact your System Administrator to review AME rules setup.



During investigation, the FND_LOG_MESSAGES shows that the below exceptions are trapped:
                                                          

MODULEMESSAGE_TEXT
po.plsql.POR_AME_APPROVAL_LIST.getAllApprovers.others_exception ORA-01403: no data found
po.plsql.POR_AME_APPROVAL_LIST.insert_approver.others_exception ORA-01403: no data found
icx.por.approval.server.ApprovalListAMImpl AMEException ORA-01403: no data found
icx.por.approval.server.ApprovalListAMImpl OAException: ICX_POR_AME_EXCEPTION errorCode=0

 



Steps to Reproduce:

1. Add an item to cart and go to Requisition checkout.
2. On Checkout: Review Approver List page, change first approver.
3. Add another approver BEFORE first approver and save.
4. Add another approver BEFORE or AFTER first approver and save, or click on Next in checkout.
5. Get error message.

Changes

1. Upgraded Database to 10.2.0.4
2. Applied baseline patches for extended support per <Note 883202.1> which included 'Procurement Rollup Patch 11' (<Patch 8555411>)
3. Applied Oracle CPU (critical patch update) for 2010 October.

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