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 laterInformation 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 |