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 11.5.10.0 and later
Information in this document applies to any platform.
INVIDITM.FMB
This document is for all users of Oracle EBS 11i and R12 and later.

Symptoms

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.

ERROR
-----------------------
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

STEPS
-----------------------
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.

Changes

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

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