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

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