My Oracle Support Banner

XItem Creation Error Occur When Re-Adding a Removed Item/Supplier or Item/Supplier/Country (Doc ID 2198428.1)

Last updated on DECEMBER 07, 2018

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 to 15.0.1 [Release 15.0]
Information in this document applies to any platform.

Symptoms

When attempting to re-add a removed Item/Supplier (or Item/Supplier/Country) through XItem RIB interface, the following errors occur, depending on the item being re-added:

Error:
Record already exists in the staging table for this item and supplier. Please delete the record to continue. SVC_ITEM_SUPPLIER
Record already exists in the staging table for this item, supplier and origin_country_id. Please delete the record to continue. SVC_ITEM_SUPP_COUNTRY

Steps to Reproduce:

Item/Supplier:
  1. Using XItem, create a new item with 2 suppliers each with 1 country.
  2. Using XItem, delete the second supplier.
  3. Notice the 'DEL' record in SVC_ITEM_SUPPLIER.
  4. Using XItem, create the item/supplier relationship deleted in #2.
  5. Notice the error:  Record already exists in the staging table for this item and supplier. Please delete the record to continue. SVC_ITEM_SUPPLIER

Item/Supplier/Country:
  1. Using XItem, create a new item with 1 supplier and 2 countries.
  2. Using XItem, delete the second country.
  3. Notice the 'DEL' in SVC_ITEM_SUPP_COUNTRY.
  4. Using XItem, create the item/supplier/country relationship deleted in #2.
  5. Notice the error:  Record already exists in the staging table for this item, supplier and origin_country_id. Please delete the record to continue. SVC_ITEM_SUPP_COUNTRY

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.