APP-FND-01934 ORA-00001 Error Occurs When Creating Items
(Doc ID 1072935.1)
Last updated on APRIL 12, 2023
Applies to:Oracle Item Master - Version 18.104.22.168 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
The following patch was applied:
<Patch 7258629> - Oracle Inventory and Receiving (PO): Release 11.5.10, Rollup Patch 12
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