Support Note KB0392822
Email
Error: "Duplicates are not allowed" when creating supplier organizations
Symptom

Attempting to import or manually create a new supplier organization causes the following error:

This value already exists. Duplicates are not allowed.


Cause

This error results from the following:


Resolution

To resolve the error:

  1. 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

  2. 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.

Additional Information

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:

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.



Applies To

Strategic Contracts > Strategic Contracts Import/Export
Strategic Sourcing > Strategic Sourcing Import/Export
Supplier Lifecycle & Performance > SM Administration

Terms of Use  |  Copyright  |  Security Disclosure  |  Privacy