My Oracle Support Banner

PR AME Approval Workflow Raises ORA-06502 PLSQL Numeric Or Value Error : Character String Buffer Too Small (Doc ID 2936365.1)

Last updated on MAY 01, 2023

Applies to:

Oracle Purchasing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

After setting up AME(Approvals Management Engine) and When PR (Purchase Requisition)approval is triggered ,Workflow runs into the below error 

ERROR
-----------------------

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-20108: The transaction ID specified returned an incorrect number of rows for TOP_SUPERVISOR_PERSON_ID. Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows


STEPS
-----------------------
1. Login to Purchasing Responsibility
2. Navigate to Purchase Requisition >Requisitions
3. Enter the Required Purchase Requisition : headers , Line and Distribution level information pertaining to Requisition
4. Click On APPROVE
5. Check the Workflow Monitor.

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!

In this Document
Symptoms
Changes
Cause
Solution


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