My Oracle Support Banner

Transformation Job Fails with ORA-01438 due to Larger Value than Specified Precision Allowed for Target Column (Doc ID 2938555.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.1.1.3 and later
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.1.1.3 version,
When attempting to submit a transformation job,
the following error occurs for one of its sub-programs:

ERROR
--------
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 1

STEPS
-------
The issue can be reproduced with the following steps:
1. Submit a transformation job.
2. Verify the job status.

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.