My Oracle Support Banner

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

Last updated on MAY 16, 2022

Applies to:

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


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.




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.