ITEM_LOC.REGULAR_UNIT_RETAIL Is Being Updated With Clearance Retail
(Doc ID 429353.1)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!