ORA-00001: unique constraint (DP.T_EP_SIZ_DES_EP_ID_IDX) violated Error While Running Ep_load_items And Ep_load_locations - 12.2.4 + (Doc ID 1944127.1)

Last updated on MAY 14, 2015

Applies to:

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

Symptoms

PROBLEM
-------------

On :  12.2.4 version, LoadData


When attempting to load data after creating a new level from Data Model,
the following error occurs.

ERROR
-----------------------

1)getting error when  running EP_LOAD_ITEMS

ORA-00001: unique constraint (DEMANTRA.T_EP_SIZ_DES_EP_ID_IDX) violated
ORA-06512: at "DEMANTRA.EP_LOAD_ITEMS", line 2480
ORA-06512: at line 2


2)getting error when running EP_LOAD_LOCATIONS

ORA-00001: unique constraint (DEMANTRA.T_EP_SUBS_MGR_EP_ID_IDX) violated
ORA-06512: at "DEMANTRA.EP_LOAD_LOCATIONS", line 2300
ORA-06512: at line 2

We have created the levels using data model option in business modeler.

All the indexes made on the level fields in items table and location table are unique indexes.

STEPS
--------
Issue can be reproduce by inserting data in t_src_item_tmpl ,t_src_location_tmpl,t_src_sales_tmpl
and running procedure

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Business Modeler

2. Add new level from Data Model

3. Upgrade successfully the existing data model

4. Insert data into t_src_item_tmpl ,t_src_location_tmpl,t_src_sales_tmpl

5. Try to load data using Ebs Full Download workflow or ep_load_main procedure

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