My Oracle Support Banner

Clearance Reset At Zone Level Not Creating Record In RPM_FUTURE_RETAIL (Doc ID 2498393.1)

Last updated on JUNE 14, 2019

Applies to:

Oracle Retail Price Management - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 14.1.3 version, Clearances


  You observe that, in some cases, clearance reset applied on zone level is not creating records in RPM_FUTURE_RETAIL (RFR)


The issue can be reproduced at will with the following steps: 

  1. Select an item that is already in a past clearance for Zone-1
  2. Item is having null reset date in RPM_CLEARANCE, i.e., not reset at zone level
  3. Item clearance was reset at Location level using create clearance reset
  4. New store was created for Zone-1 & automatically clearance got applied on the item/new location
  5. New Clearance Reset record created for new location with null effective date
  6. Perform from RPM - Reset Clearance at Zone level, and notice it’s not creating any RFR record
  7. Perform from RPM - Reset Clearance at Zone level with different reset date, and notice it also does not work.




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.