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

Last updated on APRIL 17, 2021

Applies to:

Symptoms

 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.