My Oracle Support Banner

Error ORA-06502: PL/SQL: Numeric Or Value Error When Running Resource Transaction Manager (Doc ID 2423589.1)

Last updated on NOVEMBER 08, 2019

Applies to:

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


On : 12.2.5 version, Batches

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

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

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.


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.