WIP Cost Collection Worker Fails With ORA-6502: PL/SQL: Numeric Or Value Error
(Doc ID 2083485.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, WIP Costing
When attempting to run cost collection the following error occurs in WIP Cost collection Worker.
CMCCCW Module : WIP Cost Collection Worker
CSTPPCCB.pm_check_error_wt(30): ORA-6502: PL/SQL: numeric or value error:
character string buffer too small * CSTPPCCB.pm_mark_error_wt(30):
ORA-1400: cannot insert NULL into ("WIP"."WIP_TXN_INTERFACE_ERRORS"."ERROR_MESSAGE")
The issue can be reproduced at will with the following steps:
1. Assign expenditure organization whose length is more than 60 chars in Department setup
2. perform direct item transaction against a project referenced work order
3. Run Cost collection
4. Observe WIP cost collection worker fails with error
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