SAP Knowledge Base Article - Public

3803431 - Error: Sequence ID Source_XXX / DESTINATION_YYY Already Exists

Symptom

System triggers below error when creating new Material Flow Rules for a Logistics Area
Error: "Sequence ID Source_XXX already exists"
          "Sequence ID DESTINATION_YYY already exists"

XXX represents the Source sequence ID, YYY represents the Destination sequence ID

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supply Chain Design Master Data work center.
  2. Go to Locations view.
  3. Search and select the Site ABC (ABC represents the Site ID).
  4. Choose Edit Layout.
  5. Select the Logistics area DEF (DEF represents the Logistics area ID).
  6. Go to Material Flow Rules Tab.
  7. Choose Create.
  8. Select Advanced rule.
  9. The Error occurs,
    Sequence ID DESTINATION_XXX already exists
    Sequence ID SOURCE_YYY already exists
    (XXX represents the Source sequence ID, YYY represents the Destination sequence ID)

Cause

  • When creating a new Material Flow Rule, system automatically generates the Sequence ID based on the last auto-generated Sequence ID. 
  • The material flow rules can be created manually or by migration using a different Sequence ID.
  • When creating a new material flow rule, the system continues to generate the Sequence ID based on the previous auto-generated ID, instead of the latest manually used ID.
  • If the generated Sequence ID already exists, the system displays the error "Sequence ID Source_XXX / DESTINATION_YYY already exists" (XXX represents the Source sequence ID, YYY represents the Destination sequence ID).

Resolution

  1. This is the standard system behavior.
  2. If the automatically generated Sequence ID already exists, manually change it to a unique Sequence ID that is not currently in use. Once a unique Sequence ID is entered, the Material Flow Rule can be created and saved successfully.

See Also

2568622 - Error "Logistics Area ID in Sequence Item ABC\DESTINATION_XYZ\1 Not Defined or Not Valid"

Keywords

Material Flow Rule; Logistics Area; Sequence ID; Sequence ID already exists; Source sequence ID; Destination sequence ID; Auto-Generated; SAP ByDesign , KBA , AP-LDM , Location Data Management , Problem

Product

SAP Business ByDesign all versions