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 APRIL 20, 2023

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.