Demantra Upgrade Data Model Giving: Error In Procedure ADD_CONSTRAINTS ORA-06502: PL/SQL: Numeric (Doc ID 1523740.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Error in Procedure ADD_CONSTRAINTS ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error in Procedure BUILD_MODEL ORA-20001: Error in Procedure ADD_CONSTRAINTS ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error in Procedure BUILD_MODEL ORA-20001: Error in Procedure ADD_CONSTRAINTS ORA-06502: PL/SQL: numeric or value error: character string buffer too small
We create two new custom levels in Data Model. This was working in fine in our other development instance which was in Windows based server.
Bus Impact - this is a highly visible show stopper issue 

Solution

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