The Data Conversion Tool Errors Out Item-Supplier Records When the Primary Supplier does not Match Between the Style and SKU (Doc ID 2830837.1)

Last updated on JANUARY 11, 2024

Applies to:

Symptoms

The data conversion tool errors out item-supplier records when the primary supplier doesnt match between the Style and SKU.

Error:
The primary supplier of the item does not match with the primary supplier of its parent or grandparent

Steps To Recreate:
1. Create a dc_item*.zip file with ITEM_MASTER, ITEM_SUPPLIER , ITEM_SUPP_COUNTRY and ITEM_SUPP_MANU_COUNTRY files inside the zip file.
2. ITEM_MASTER - create a record for 1 Style, 1 SKU and 1 UPC.
3. ITEM_SUPPLIER  - For style only 1 supplier exists (ex. 123), For SKU add supplier 123 as non primary and 456 as primary. For UPC add supplier 123 as non primary and 456 as primary.
4. ITEM_SUPP_COUNTRY  - Add records for each item-supplier combination with country of sourcing as US.
5. ITEM_SUPP_MANU_COUNTRY - Add records for each item-supplier combination with country of manufacture as US.
6. Load this file into Data Conversion tool using DC_ITEM entity.
7. Some records failed with error : "The primary supplier of the item does not match with the primary supplier of its parent or grandparent".
8. Check for the items loaded. The SKU item has loaded in approved status with no primary 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.