My Oracle Support Banner

Retail Price Is Different between Parent Item and Child Item when Ranging the Location to Child Item (Doc ID 2559611.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Prices defined at the parent level is overriding the prices defined at child item level.

Steps to reproduce:

  1. Create parent item(say P1).
  2. While adding the retail price by 'Retail by zone' pricing for the parent item P1, edit the retail price for zone Z1(say for example, edit retail to 40).
  3. Create 4 children items( say I1, I2, I3 and I4) for this parent item P1.
  4. During 'Retail by Zone' pricing for the child items I3 and I4, edit the retail price for Zone Z1 to 45(i.e., I3 and I4 will have retail different than its parent P1).
  5. Check for the retail price of the items P1, I1, I2, I3 and I4 in RPM_ITEM_ZONE_PRICE Table for the zone Z1.
  6. Their prices should be as P1 - 40 , I1 - 40 , I2 - 40 , I3 - 45 and I4 - 45 for the zone Z1 in the table.
  7.  Next range the parent item to location L1 of the zone Z1.
  8. While checking the retail price for the child items I3 and I4 in ITEM_LOC table for L1 the expected retail price should be 45 but the actual price for the items I3 and I4 in the ITEM_LOC table is 40.




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.