My Oracle Support Banner

Orddscnt Batch Performance Issue (Doc ID 2684624.1)

Last updated on JUNE 29, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

Orddscnt batch is running for a long period of time.

Steps to replicate the issue:

  1. Create order for the item /location/supplier on which deal is active.
  2. Notice entry comes into deal_calc_queue table.
  3. Run the orddscnt batch.

Notice for 10K(10.000) records batch is getting completed in 30 minutes. Expected time is 10 minutes on a very high end.

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
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.