ORA-00001: Unique Constraint (ENI.ENI_OLTP_ITEM_STAR_U3) Violated In Package ENI_ITEMS_STAR_PKG in OPM Migration (Doc ID 1460657.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

For some items, the OPM item migration procedure, inv_opm_item_migration.get_odm_item gives the message: ORA-00001: unique constraint (ENI.ENI_OLTP_ITEM_STAR_U3) violated in Package ENI_ITEMS_STAR_PKG Procedure INSERT_ITEMS_IN_STAR
 

Solution

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