ITEM_LOC.REGULAR_UNIT_RETAIL Is Being Updated With Clearance Retail
Last updated on SEPTEMBER 16, 2016
Applies to:Oracle Retail Price Management - Version 12.0.2 and later
Information in this document applies to any platform.
Checked for currency on 22/7/2010
If a clearance price change is approved and executed in RPM)for a particular item
and location, the regular_unit_retail value on ITEM_LOC table also gets updated with clearance price for that
Expect the field should represent the regular unit retail of the item and not the clearance retail. The clearance retail
is written to the UNIT_RETAIL field.
The issue can be reproduced at will with the following steps:
1. Create a clearance for an RMS SKU/1 location in RPM.
2. Approve the clearance in RPM
3. Execute the batch PriceEventExecution.
4. Notice that both the UNIT_RETAIL and REGULAR_UNIT_RETAIL fields on ITEM_LOC
were updated with the clearance price. REGULAR_UNIT_RETAIL field should NOT be updated.
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