APP-FND-01934 ORA-00001: Unique Constraint Error at Master Items

APP-FND-01934 ORA-00001: Unique Constraint Error at Master Items

Resolution:

This error could be solved by recompiling System Items Key Flexfield (KFF).
To recompile Inventory Flexfields, please do the following:
To recompile Inventory Flexfields, please do the following:

1. Go to: Inventory responsibility.

2. Navigate to: Setup > Flexfields > Key > Segments 

3. Query up the Application: Inventory and Flexfield title: "System Items".

4. Click off Freeze Flexfield Definition. Click OK to the caution message. 

5. Click again the Freeze Flexfield Definition radio button. Click ok to the Caution message. 

6. Click on Compile. This will kick off concurrent request Flexfield View Generator. Verify that it completes without error. 

7. Retest the issue.

If the KFF recompile does not solve the error, please go to the alternate solution below: 

1. Take a backup of ENI.ENI_OLTP_ITEM_STAR. 

2. Truncate table ENI.ENI_OLTP_ITEM_STAR. 

3. Go to Business Intelligence Administrator > Daily Processing > Run. 

2. Choose Request Set and click OK. 

4. In the Find screen enter: Load Item Dimension Hierarchy. 

5. Run "Load Item Dimension Hierarchy" concurrent program. 

6. Retest the issue. 

7. Migrate the solution as appropriate to other environment