My Oracle Support Banner

Likestore Batch Copies the Wrong Retails for Items that Are on Clearance (Doc ID 1397815.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


The like store batch (Likestore.pc) copies the wrong retails for items that are on clearance.

Creating a new store using the like store batch is creating the items on the clearance at the new store with the UNIT_RETAIL of the like store as the REGULAR_UNIT_RETAIL of the new store. The REGULAR_UNIT_RETAIL, UNIT_RETAIL and the SELLING_UNIT_RETAIL are all the clearance retails for the item at the like store that are inherited to the new store, but the item is not on clearance at the new store.

Steps to Reproduce:
1. Create a store using the like store functionality.
2. Run Storeadd, Likestore and Prepost batches.
3. Check the newly created STORE / ITEM_LOC combination.
Observe that items on clearance at the like store are also copied to the new store but will not be on clearance. However the retails that are copied to the new store are wrong; the UNIT_RETAIL and SELLING_UNIT_RETAIL of the like store are copied to the new store instead of copying the REGULAR_UNIT_RETAIL of the like store as the retails.




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.