Error ORA-06502: PL/SQL: Numeric Or Value Error When Running Resource Transaction Manager

(Doc ID 2423589.1)

Last updated on JULY 19, 2018

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Batches

When attempting to run the Resource Transaction Manager,
the following error occurs.

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Responsibility: Production Supervisor

2. Perform the steps to retrieve OSP PO
Inventory >> Transactions >> Receiving >> Corrections

3. Perform a check and see the original Qty. received was 265.3, need only 250 kgs, therefore the user entered -15.3 kgs in the Deliver line, backdated the transaction to 03/22/2018 00:00:00 and saved data.

4. Perform the steps to retrieve OSP PO 51109, again
Inventory >> Transactions >> Receiving >> Corrections

5. Perform the steps to enter and saved data.

6. Perform a check of the receiving transactions to validate all transactions are OK, enter PO number
Inventory >> Transactions >> Receiving >> View Receiving Transactions. Perform a check to verify all transactions are correct and see they are correct.

8. Run the Resource Transaction Manager concurrent request.
Production Supervisor >> View >> Request >> Submit a New Request >> Resource Transactions Manager

9. Perform a check of the Resource Transaction Worker log file and see that it ends with error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.


Changes

 

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