My Oracle Support Banner

AME Error For Work Confirmation Approval - UPDATE_APPROVAL_RESPONSE_AME - ORA-06502: PL/SQL: numeric or value error (Doc ID 2357164.1)

Last updated on MARCH 21, 2018

Applies to:

Oracle iSupplier Portal - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, AME Setup issues , in Prod

When attempting to submit the work confirmation,
the following error occurs.

ERROR
-----------------------
**** Errored Activities

Activity RESULT Error Name
--------------------------------------------- --------------- ------------------------------
Error Message
------------------------------------------------------------------------------------------------------------------------------------
Error Stack
------------------------------------------------------------------------------------------------------------------------------------
UPDATE_APPROVAL_RESPONSE_AME #EXCEPTION -6502
ORA-06502: PL/SQL: numeric or value error

Wf_Directory.GetUserName(PER, 695)
Wf_Engine_Util.Function_Call(POS_WCAPPROVE_PVT.UPDATE_APPROVAL_LIST_RESPONSE, WCAPPRV, 361316-391031, 280069, RUN)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to application
2. Submit Work Confirmation for approval
3. It goes to requester and after the requester approving as per AME, it should go forward as per the AME rule
4. Instead as soon as the requester approves the work confirmation gives the above error to sysadmin.



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.