My Oracle Support Banner

ORA-01438: value larger than specified precision allowed for MDS.MDS_PPM_ACTIVITY_FS_PRO (Doc ID 2454500.1)

Last updated on MAY 21, 2020

Applies to:

Oracle Product Lifecycle Analytics - Version 3.4.0 to 3.6.1 [Release 3.4.0 to 3.6.0]
Information in this document applies to any platform.

Symptoms

On : 3.4.0 version, Agile PLM 9x Extract (SDE)

MDS load fails with ORA-01438: value larger than specified precision allowed for MDS.MDS_PPM_ACTIVITY_FS_PRO.

ERROR
-----------------------
Session Failed :551479103 : ODI-1217: Session ODI_PKG_MDS_PPM_DATA_LOAD
(551479103) fails with return code 1438.
ODI-1226: Step exec of BI_PPM_ACTIVITY_FS_PRO fails after 1 attempt(s).
ODI-1232: Procedure odi_pro_BI_PPM_ACTIVITY_FS_pro execution fails.
ODI-1228: Task odi_pro_BI_PPM_ACTIVITY_FS_pro (Procedure) fails on the target
ORACLE connection TRG_BI_PHYSICAL.
Caused By: java.sql.SQLDataException: ORA-01438: value larger than specified
precision allowed for this column
ORA-06512: at "MDS.MDS_PPM_ACTIVITY_FS_PRO", line 691
ORA-06512: at line 2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start Full MDS load


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.