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 FEBRUARY 05, 2018

Applies to:

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


On : 12.2.4 version, AME Setup issues , in Prod

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

**** Errored Activities

Activity RESULT Error Name
--------------------------------------------- --------------- ------------------------------
Error Message
Error Stack
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)

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.




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