My Oracle Support Banner

Location Move Not Ending The Clearances When Moved To New Zone.Unable To End The Clearance (Doc ID 2461884.1)

Last updated on OCTOBER 24, 2018

Applies to:

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

Symptoms

When location is moved to new zone it will not end the clearance as there no records in reset table for the items when moved to new zone. 

Steps to Reproduce: :

  1. Create Clearance for item/zone(Zone 1) level on vdate. Clearance will be in executed status.
  2. Create location move(L1) from Zone 1 to Zone 2.
  3. Run locationmoveschedule batch.
  4. Run locationmovebatch.
  5. Verify the records in rpm_future_retail. Clearance was imported to new zone 2 for the location L1 without reset date.
  6. No reset records are available in rpm_clearance_reset table, because of this we are not able to end the clearance also.

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.