"Approval List Could Not Be Generated" on some iProcurement Punchout Requisitions (Doc ID 1939801.1)

Last updated on MARCH 10, 2016

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approval List and Workflow

For some selected users iProcurement punchout requisitions result in error.  
This happens intermittently. It seems some users punchout requisition from Oracle iProcurement could not be submitted for approval after checking out, due to the error.

Due to this issue, some users cannot submit punch out orders. This causes big problem to the progress of our scientific research projects.

 
Error

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


FND_LOG_MESSAGES shows following error:

icx.por.common.server.TransactionUtil 2 getPorAppsContext.begin
icx.por.approval.server.ApprovalListAMImpl 2 isPoApproval.FALSE end
icx.por.approval.server.ApprovalListAMImpl 2 ameBuildApprovalListForPreparer.begin
icx.por.approval.server.ApprovalListAMImpl 2 ameInitQuery: Input Params:: reqId = 499686; defaultFlag = true; approvercheckout = false; resetFlag = false
icx.por.approval.server.ApprovalListAMImpl 1 ameInitQuery: ameGetAllApprovers: returns EXCEPTION:ORA-06502: PL/SQL: numeric or value error: character string buffer too small
icx.por.approval.server.ApprovalListAMImpl 1 ameGetAllApprovers: returns approversCount0
icx.por.approval.server.ApprovalListAMImpl 1 in else
icx.por.common.server.TransactionUtil 2 getPorAppsContext.begin
icx.por.approval.server.ApprovalListAMImpl 1 in eflowPreparerCheckoutFlow
icx.por.approval.server.ApprovalListAMImpl 2 GET_AME_OWNER_APPROVE: Input Params docType = PURCHASE
icx.por.approval.server.ApprovalListAMImpl 1 GET_AME_OWNER_APPROVE: returns Y
icx.por.approval.server.ApprovalListAMImpl 1 Approval List could not be generated.
icx.por.approval.server.ApprovalListAMImpl 2 ameBuildApprovalListForPreparer.end


Steps To Reproduce
1. Log in and access iProcurement
2. Punchout to Supplier and return cart
3. Checkout
4. Encounter the error at either :
-- Submit page
-- Or when after the "Back" button is pressed and then "next" button is pressed on the "Checkout: Approvals and Notes' page .


 


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