My Oracle Support Banner

Error In Data Model MDP_MATRIX_ADD_LUD_COLS ORA-01401: inserted value too large for column (Doc ID 2077276.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Customer is on 12.2.4.1

They have added a new location level and thereafter ran the upgrade data model. Steps followed were:

 



Step 1: Added four columns in t_src_loc_tmpl
Step 2: Open data model, create levels
Step 3: Upgrade data model.

 

They are getting below error in when they ran the upgrade data model:

MDP_MATRIX_ADD_LUD_COLS -1401 ORA-01401: inserted value too large for column Error in PROCEDURE line 1295

  dynamic_ddl( 'ALTER TABLE MDP_MATRIX_T MODIFY PREDICTION_STATUS DEFAULT '98' ')

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.