My Oracle Support Banner

Actual Cost Worker Failed Err WIP_COST_TXN_INTERFACE ORA-06502: PL/SQL: numeric or value error: character string buffer (Doc ID 2860156.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Cost Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, WIP Costing

When attempting to cost Transactions
the following error occurs.

In PROD , Actual Cost Worker program showing the following error also in table WIP_COST_TXN_INTERFACE i

ERROR
-----------------------
cmlctw returned error code : 0 in res_ovhd
Direct Item grp id = 13570466 in res_ovhd
res_ovhd failed. it was called to process resource&ovhd only.
res_ovhd returned error code : 9999
Processing job 6816063
exceptionORA-06502: PL/SQL: numeric or value error: character string buffer too small


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigate to : EAM system Administrator -> EAM * Work Order Transactions * Pending
Resource Transactions



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
References


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