My Oracle Support Banner

Price Change Information Updates Incorrectly in ITEM_LOC Table of RMS (Doc ID 1957128.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Retail Price Management - Version 14.0.1 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.
checked for relevance on 07-DEC-2016


Price change information updates incorrectly in the ITEM_LOC table of Retail Merchandising System (RMS).

Steps to Reproduce:

  1. Log in to Oracle Retail Price Management (RPM).
  2. Navigate to Create Price Change screen.
  3. Create a Price Change taking parent item and exclude the child item. 
  4. Run the Price Event Execution batch.
  5. Verify information in the ITEM_LOC and RPM_FUTURE_RETAIL table.
  6. Note that the ITEM_LOC table is not updated with the expected result.
    a. UNIT_RETAIL and SELLING_UNIT_RETAIL are updated incorrectly in ITEM_LOC table for the excluded item.
    b. Price change for parent item: the UNIT_RETAIL and SELLING_UNIT_RETAIL are not updated with the new value.




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.