My Oracle Support Banner

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.

Symptoms

On : 12.1.3 version, WIP Costing

When attempting to run cost collection the following error occurs in WIP Cost collection Worker.

ERROR

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")


STEPS

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

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