Price Change Incorrectly Updates UNIT_RETAIL, SELLING_UNIT_RETAIL in ITEM_LOC For Item Set For Exclusion (Doc ID 1950909.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Retail Price Management - Version 13.2.6 and later
Information in this document applies to any platform.
checked for relevance on 07-DEC-2016

Symptoms

The article described in this document is known to Oracle, and a fix already scheduled for future release. This article will be updated as official patch information becomes available.

 While creating Price change, it incorrectly updates  UNIT_RETAIL, SELLING_UNIT_RETAIL in ITEM_LOC table for the item set for exclusion of RMS database. CLEAR_RETAIL and SELLING_RETAIL in RPM_FUTURE_RETAIL table was updated correctly  for parent item as well as child item.


Steps to Recreate:
1.Login in to Oracle Retail Price Management (RPM)
2.Create a price change taking parent item and exclude the child item .
3. verify the ITEM_LOC and RPM_FUTURE_RETAIL

Actual result:

1.UNIT_RETAIL, SELLING_UNIT_RETAIL in ITEM_LOC table was incorrectly updated for exclude item.
2.price change for parent item , the UNIT_RETAIL and SELLING_UNIT_RETAIL was not updated with new value.

Expected Result:

1.UNIT_RETAIL and SELLING_UNIT_RETAIL should be updated correctly in ITEM_LOC table for exclude item.
2.price change for parent item ,UNIT_RETAIL and SELLING_UNIT_RETAIL should be updated with new value in ITEM_LOC table.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms