Error: "Duplicates are not allowed" when creating supplier organizations
Attempting to import or manually create a new supplier organization causes the following error:
This value already exists. Duplicates are not allowed.
This error results from the following:
- An existing supplier organization has the same name.
- An existing supplier organization has the same ID.
To resolve the error:
- Make sure the supplier organization name is unique. Keep in mind that this field is case sensitive. For testing purposes, you can change the case to bypass the duplicate value error. See additional information for a best practice in this area.
For example:
- Existing supplier organization name: Test ORG
- To resolve the error, change the name for the new supplier: Test Org
- The organization ID must also be unique.
- The site automatically assigns an ID value when you create a supplier organization manually.
- You assign an ID value when you import a supplier organization for the first time. In this case, modify the ID in your file to one that is not already assigned to another supplier organization.
Additionally, the SupplierIDs.csv file, which accompanies the SupplierOrganizations.csv file, defines organization IDs, such as the SAP Business Network ID (ANID) or buyersystemid. These IDs may be loaded onto one supplier at a time. Trying to put the same organization ID onto multiple suppliers results in errors.
If an import is run using a method that allows both Create and Update actions, and if Ariba does not recognize that you are updating an existing supplier, it will then attempt to create a new supplier. Subsequently, if Ariba finds that the import file's organization IDs are already in use, an error message appears on the import task.
To resolve this issue:
- Verify that the supplier already created in your system uses the intended System ID and organization IDs
-
- Note that the SystemID of a supplier cannot be edited. If existing suppliers are not using the intended System ID, the following two options are available:
- The import file must be adjusted to use the logged SystemID
- The supplier must be deleted out of the system
-
- If existing suppliers are not using the correct organization IDs, these can be updated either through the user interface or through another import.
- Verify that the import file, SupplierOrganization.csv, references the correct SystemID for all suppliers. Adjust as necessary.
- Verify that the import file, SupplierIDs.csv, references the correct Organization IDs for all suppliers. Adjust as necessary.
As a best practice, make sure to create distinct supplier organization names. Though your site allows you to create a supplier organization with the same name but different case, this might make it difficult to distinguish between the two supplier organizations, leading users to select the incorrect supplier organization in projects or events.
Strategic Contracts > Strategic Contracts Import/Export
Strategic Sourcing > Strategic Sourcing Import/Export
Supplier Lifecycle & Performance > SM Administration