My Oracle Support Banner

export_itemloc Duplicated Records In Export File When Deleting Style Items With UPCs (Doc ID 2653232.1)

Last updated on APRIL 14, 2021

Applies to:

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

Symptoms


When deleting items with UPCs, the UPCs are written twice in the item master extract for store level files.


Steps to reproduce:

  1. Delete a Style item via RMS UI (one with SKUs and UPCs).
  2. Run the dlyprg batch and check if the items have been deleted from ITEM_MASTER.
  3. Run export_itemmaster.ksh.
  4. Run export_itemvat.ksh.
  5. Run export_itemloc.ksh. Notice that all the level 3 items are written twice in the file itemhdr file.

Changes

 

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
Changes
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.