APP-FND-01934 ORA-00001 Error Occurs When Creating Items
Last updated on JUNE 22, 2017
Applies to:Oracle Item Master - Version 126.96.36.199 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
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