My Oracle Support Banner

UPC Items Created in Retail Merchandising System Not Going To XStore (Doc ID 2626644.1)

Last updated on APRIL 15, 2021

Applies to:

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


Universal Product Code items (UPC) are not flowing to Xstore Point-of-Service.

Steps to reproduce:

  1. Create item with UPC/EAN item at transaction level. Observe payload data in item_export_stg.
  2. Run xStore_Deltas (all batches related to delta transfer from RMS to Xstore).
  3. Run purge batch on RMS side (dlyprg).
  4. Create a new UPC/EAN item and delete the old one with default new item description to all item/locations.
    (e.g. delete UPC, process xstore_delta batches, create upc, process xstore_delta batches).
  5. Observe the new UPC is not sent to Xstore.
Note: by xStore_Deltas the following batches/commands are referenced:

.../export_merchhier.ksh <user/password> delta
.../export_orghier.ksh <user/password> delta
.../export_stores.ksh <user/password> delta
.../export_diffs.ksh <user/password> delta
.../export_diffgrp.ksh <user/password> delta
.../export_itemmaster.ksh <user/password> delta N
.../export_itemloc.ksh <user/password> delta N
.../export_itemvat.ksh <user/password> delta N
.../export_relitem.ksh <user/password> delta N
.../export_vat.ksh <user/password> delta
.../export_stg_purge.ksh <user/password>


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

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