My Oracle Support Banner

Orddscnt Batch Performance Issue (Doc ID 2684624.1)

Last updated on AUGUST 19, 2021

Applies to:

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


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.


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

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