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


Symptoms

Actual Behavior

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
item/ location

Expected Behavior
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.

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