建Item时出错APP-FND-01934: ORA-00001: unique constraint。。。

创建Item时，设置Serial @ Receipt 属性后，保存，出错：

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

上Metlink查查阿！！以下為Metlink中信息：
The information in this document applies to:
Oracle Process Manufacturing Inventory - Version: 11.5.10
This problem can occur on any platform.

Errors
ORA-02291 integrity constraint (%s.%s) violated - parent key notfound"

Symptoms
When saving a new item in OPM inventory > Setup > Item Master receive error:
ORA-02291: integrity constraint (GMI.IC_LOTS_MST_IC_ITEM_MST_B_FK) violated - parent key not found

When running the insert into ic_item_mst_b statement in sql, receive the following errors:

ORA-20001: 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
ORA-06512: at "APPS.APP_EXCEPTION", line 70
ORA-06512: at "APPS.INV_ITEM_PVT", line 2906
ORA-06512: at "APPS.GMF_PR_ITEM_INS", line 303
ORA-06512: at "APPS.GMF_IC_ITEM_MST_BIUR_TG", line 706
ORA-04088: error during execution of trigger 'APPS.GMF_IC_ITEM_MST_BIUR_TG'


Cause
Bug 4227734 - UNIQUE CONTRAINT (ENI.ENI_OLTP_ITEM_STAR_U3) ERROR IN MASTER ITEMS WINDOW


Fix
1) Recompile the "System Items" Key Flexfield which is owned by Oracle Inventory. Navigate to
Oracle Inventory > setup > flexfields > Key > Segements. Query on Application 'Inventory' and
flexfield title ' System Items'. To recompile the flexfield, uncheck the freeze flexfield
definition, accept the message. Now check the Freeze Flexfield Definition and accept the message.
Then click on the Compile button.

凍結編譯一下system item就可以了!
弹性域不冻结，意味着可以改变其结构！
ORACLE就限制住不让你写东西。。！

参考 http://www.itpub.net/thread-716868-1-1.html

Item2 SN.JPG

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7434747/viewspace-664000/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7434747/viewspace-664000/