When Creating DSD Orders For Secondary Supplier, System Checks For ORG_UNIT_ID of Primary Supplier (Doc ID 2660404.1)

Last updated on DECEMBER 01, 2021

Applies to:

Symptoms

While creating Direct Store Delivery(DSD) order for secondary supplier, system always looks for ORG_UNIT_ID of primary supplier from ITEM_SUPPLIER table  and throws below error :

Steps To Recreate:
    1. Item "XXXXX" is associated with more than 1 supplier .
        Eg :Say 2 suppliers
              Supplier YY is primary Supplier(org_unit_id "ABC")
              Supplier ZZ is secondary Supplier (org_unit_id "XYZ")

    2. Item "XXXXX" is associated to store "S1" (Org_unit_id "XYZ")

    3. Primary supplier is having different org_unit_id compared to the one of store.

    4. User is creating DSD order for the secondary supplier whose org_unit_id is same as the one of the store.

         Orders -> Create DSD Order
         Store: S1
         Supplier: ZZ
         Item: XXXXX

    5. System Reports the below error :

        Location S1 and Supplier YY are not related to the same org unit.

        Issue is that system is trying to match the ORG_UNIT_ID of primary supplier with the STORE.ORG_UNIT_ID eventhough the user is creating DSD order for the secondary supplier

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.