My Oracle Support Banner

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:

Oracle Retail Price Management - Version 13.2.6 and later
Information in this document applies to any platform.


 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.




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.