New Primary Supplier Not Added Correctly for Existing Item; PK_ITEM_COUNTRY Error Is Thrown When Creating a New SKU (Doc ID 2038012.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS) 14.1, a new primary supplier is not added correctly for an existing item, and a PK_ITEM_COUNTRY error is being thrown upon attempting to create a new item.

Steps to Reproduce:

Scenario 1:

  1. Create a new item through XItemDesc script.
  2. Add supplier1, supplier2 for the XItemDesc; make supplier1 the primary supplier. The item should be created without error.
  3. Add another supplier3 as primary supplier for the above created item.
  4. Notice the following error populated in RMS induction screen: "A country of sourcing must be added to this item/supplier relationship before the primary supplier indicator is changed"

Scenario 2:

  1. Create a Style with Item Country populated.
  2. Create a SKU for the same style.
  3. Check the CORESVC_ITEM_ERR table and note a PK_ITEM_COUNTRY error.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms