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

Last updated on JUNE 14, 2019

Applies to:

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

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