WIP Cost Collection Worker Fails With ORA-6502: PL/SQL: Numeric Or Value Error (Doc ID 2083485.1)

Last updated on FEBRUARY 10, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms