My Oracle Support Banner

The Removal of Clearance Resets in RPM Does Not Integrate Correctly With SIM When Using the Bulk Batch (Doc ID 1983992.1)

Last updated on MAY 23, 2022

Applies to:

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


The issue described in this document is reported in SIM 13.2.X and SIM 14.0.X and SIM 14.1.X versions.All patches mentioned in this note are available for download via MOS.

When a clearance reset is removed from Retail Price Management (RPM), it is not being removed from Store Inventory Management (SIM) by batch  The clearance reset still occurs on the day for which it was originally created, and it is returned to its regular retail price.   This leaves the prices in SIM inconsistent with those in RPM, RMS, and other Retail applications.

Steps to Reproduce:

  1. In RPM, find (or create) an existing clearance which is active and with Reset Date as null.
  2. Create a clearance reset by populating reset date and approve it.
  3. Run the the following batch processes to integrate to SIM:
  4. Look at RK_PRICE_CHANGE for the record.  Note that an end date on the clearance is populated as expected.
  5. In RPM, delete the clearance reset (the reset date will be null).
  6. Repeat step 3.
  7. Look at RK_PRICE_CHANGE for the record. The end date of the clearance is incorrectly populated.




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.