Deleting a Newly Created Clearance With a Reset Date Does Not Work As Expected, Resulting in Incorrect Item Price Being Displayed (Doc ID 2083470.1)

Last updated on NOVEMBER 30, 2015

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.2 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

For an item which is already on clearance when a new clearance with a reset date is created, the system updates the ITEM_PRICE.END_DATE of the previous existing clearance record with the effective date of the reset clearance record.  However, if this newly created clearance with the reset date is deleted, the END_DATE of the previous clearance is not cleaned up.

This results in Store Inventory Management (SIM) showing the regular retail for that item, even though the previous existing clearance is still active.

Steps to Reproduce:

  1. Select an item which is already on clearance.
  2. For this item, process a new clearance with reset date.
  3. Delete this newly created clearance.


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