ORA-00001: Unique Constraint (Inv.Mtl_mfg_part_numbers_u1) (Doc ID 1394935.1)

Last updated on JANUARY 27, 2017

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 3.1 to 3.1 [Release 3.1]
Information in this document applies to any platform.

Symptoms

For existing items in both Agile and Oracle E-Business Suite, the cross reference records needs to be loaded to avoid the integration creating the items again.

Steps to load the cross reference records are documented in the 'Oracle Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite Design to Release 11.1 - Implementation Guide' on 'Chapter 10: Configuring Process Integration for Agile PLM Oracle E-Business Suite -> 10.1.5 SQL Script for Loading Cross-Reference Records'.

Once the records are loaded to the cross reference table and the following errors still occurs:

1. For an existing item sync the CreateEngineeringChangeOrderListEbizProvABCSImplProcess errors with:

<corecom:FaultMessage>
       <corecom:Code listID="" listAgencyID="" listVersionID=""/>
       <corecom:Text languageCode="" languageLocaleCode="">Org Code: ORG ECO Name: 
        EC6320 Err Msg: ORA-00001: unique constraint (INV.MTL_MFG_PART_NUMBERS_U1)   
        violated INV_EBI_ITEM_HELPER.process_part_num_association </corecom:Text>
       <corecom:Severity listID="" listAgencyID="" listVersionID="">1</corecom:Severity>
       <corecom:Stack languageCode="" languageLocaleCode=""/>
</corecom:FaultMessage>



2. For an existing redlined components in affected items where there's an updated quantity the CreateEngineeringChangeOrderListEbizProvABCSImplProcess completes successfully but when trying to Implement the ECO on Oracle E-Business Suite an error occurs:

Implementation failed: Unable to add or change component 123-123
Cause: Implementation attempted to add Component, 123-123, to operation &OP_SEQ_NUM, which already exists on the Bill of Material.

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