My Oracle Support Banner

XItemSupCre Fails With Primary_supp_ind = Y (Doc ID 2894977.1)

Last updated on SEPTEMBER 15, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

Xitemsupcre for barcode item fails with below error if primary_supp_ind = Y.

Error ORA-20001: An item can have only one primary supplier.Field: PRIMARY_SUPP_IND,ITEM:0000000750035,SUPPLIER:2200 returned by program unit CORESVC_ITEM.PROCESS_IS.

Steps to reproduce:
----------------------------
1. Ensure that the CORESVC_ITEM_CONFIG table has the following columns set to N
CASCADE_IUD_ITEM_SUPPLIER
CASCADE_IUD_ITEM_SUPP_COUNTRY
CASCADE_IUD_ISC_DIMENSIONS
CASCADE_IUD_ISMC
2. Send a XItemSupCre for a STYLE (ITEM_LEVEL = 1) with the field primary_supp_ind = 'Y' with a new supplier/country. Validate that the supplier was added to the item and that the new supplier is now the primary supplier.
3. Send a XItemSupCre for a SKU (ITEM_LEVEL = 2) with the field primary_supp_ind = 'Y' with a new supplier/country. Validate that the supplier was added to the item and that the new supplier is now the primary supplier.
4. Send a XItemSupCre for a BARCODE (ITEM_LEVEL = 3) with the field primary_supp_ind = 'Y' with a new supplier/ country. Note it fails with above error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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