Transformation Job Fails with 'ORA-01438: value larger than specified precision allowed for this column' (Doc ID 2883300.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 2.5.2 version,

When attempting to submit a transformation job,
the following error occurs:

ERROR
-----------------------

******************** ERROR ********************
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W###_#######_1.PKG_EBDRECON.PRC_EBDRECON ; end;" caught:java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "CDR_W###_#######_1.PKG_EBDRECON", line 7
ORA-06512: at line 1
******************** ERROR ********************


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Login to DMW.
2. Select a study in Development lifecycle.
3. Navigate to a transformation.
4. Add one more table to that transformation.
5. Install the transformation.
6. Submit the transformation.

Cause

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