APP-FND-01934 ORA-00001 Error Occurs When Creating Items

(Doc ID 1072935.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Item Master - Version and later
Information in this document applies to any platform.
This document is for all users of Oracle EBS 11i and R12 and later.


After applying INV RUP 12 <Patch 7258629>, any attempt to create an Item and save it, whether directly through the Item Master Form INVIDITM.fmb or through a template, results in the below errors.

APP-FND-01934: ORA-00001: unique constraint (ENI.ENI_OLTP_ITEM_STAR_U3) violated in Package ENI_ITEMS_STAR_PKG Procedure INSERT_ITEMS_IN_STAR

The issue can be reproduced at will with the following steps:
1. Tools: Copy From: xxxx Template
2. Click Apply
3. Click Done
4. Enter description
5. Click Save
6. Get error message

NOTE:  This applies to customers who do not have the Daily Business Intelligence product installed and in use (non-DBI customers).  If you do have the Daily Business Intelligence product installed, please see <Note 465008.1> - APP-FND-01934 ORA-00001: Unique Constraint Error at Master Items.


The following patch was applied:
<Patch 7258629> - Oracle Inventory and Receiving (PO): Release 11.5.10, Rollup Patch 12


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