My Oracle Support Banner

ORA-00001: unique constraint (<SCHEMA NAME>.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 FEBRUARY 13, 2019

Applies to:

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



On :  12.2.4 version, LoadData

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


1)getting error when  running EP_LOAD_ITEMS

ORA-00001: unique constraint (<SCHEMA NAME>.T_EP_SIZ_DES_EP_ID_IDX) violated
ORA-06512: at "<SCHEMA NAME>.EP_LOAD_ITEMS", line 2480
ORA-06512: at line 2

2)getting error when running EP_LOAD_LOCATIONS

ORA-00001: unique constraint (<SCHEMA_NAME>.T_EP_SUBS_MGR_EP_ID_IDX) violated
ORA-06512: at "<SCHEMA_NAME>.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.

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

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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.