OPLA 3.5 MDS ETL Failing If More than 400 Attribute Mappings Configured in OPLA Configurator

(Doc ID 2161393.1)

Last updated on JULY 15, 2016

Applies to:

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


On : 3.5.0 version, MDS Load for Agile PLM 9x

MDS FULL ETL fails on odi_pro_BI_MVIEW_PRO


ODI-1228: Task odi_pro_BI_MVIEW_PRO (Procedure) fails on the target ORACLE connection TRG_BI_PHYSICAL.
Caused By: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "MDS.MDS_MVIEW_PRO", line 153


The issue can be reproduced at will with the following steps:

1. In OPLA Configurator, Configure more than 400 attribute mappings

2. Execute MDS full load


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