My Oracle Support Banner

Oracle Demantra Load Data Error - ORA-01400: cannot insert NULL into MDP_MATRIX.T_EP_MANUFACTURER_LUD (Doc ID 1917223.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On :  7.3.1 version, LoadData

When attempting to load mdp_matrix combinations
the following error occurs.

ERROR
-----------------------
Running: MDP_ADD('mdp_load_assist')
---------------------------------------------------------------
 DB_Command::Execute threw an exception:
 {call MDP_ADD('mdp_load_assist')}
 Parameter 0 : NULL
 Parameter 1 : NULL
---------------------------------------------------------------
Database Error
 - Source: Microsoft OLE DB Provider for Oracle
 - Description: ORA-20002: -20003 ORA-20003:  Error in PROCEDURE MDP_ADD line 882
     executing dynamic_proc('dynamic_mdp_add')
ORA-06512: at "DP.SEND_ERR_MESSAGE", line 21
ORA-06512: at "DP.DYNAMIC_PROC", line 14
ORA-06512: at "DP.MDP_ADD", line 882
ORA-06512: at line 1
 - Message: Unspecified error
 - Error Number: -2147467259

 

When manually execute dynamic_mdp_add procedure from some SQL Tool like SQL Developer, got the bellow error:

begin

  dynamic_mdp_add;

end;

ORA-01400: cannot insert NULL into MDP_MATRIX.T_EP_MANUFACTURER_LUD

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. load data into demantra staging tables
2. run ep_load_main
3. got error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, new combinations are not loaded and therefore new combinations are not visible in Demantra.

Changes

 Reorg mdp_matrix table

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
Changes
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.