PLP_RETAILSALESSCCLDPLCDYWKCURRRECLASSAGGREGATE Never Completes When Items Are Reclassified (Doc ID 1992594.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising Analytics - Version 13.2.3 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Analytics (RA) 13.2.3, after applying <Patch 16984958> (which fixes Reclassification issues), a performance issue can be noted in PLP_RETAILSALESSCCLDPLCDYWKCURRRECLASSAGGREGATE.  The job never successfully completes.


Steps to Reproduce:

  1. Apply <Patch 16984958>.
  2. Run daily batches for reclassification.
  3. Note that the RETAILSALESSCCLDPLCDYWKCURRRECLASSAGGREGATE job never completes.

Cause

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