Performance Issue With RMS Ordprg.pc (Order Purge) Batch (Doc ID 1561585.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

There are performance issues with the ordprg.pc (order purge) batch.

The program was executed to delete 36000 records using the base settings (commit max ctr = 1, num_thread = 1) and was killed after running for over an hour.
The base settings were modified (commit max ctr = 1000, num_thread = 5) to run the program in parallel and the program still did not finish after running for more than 3 hours.


Steps to Reproduce:

  1. Create a number of Purchase Orders (POs).
  2. Receive the POs for step 1.
  3. Run docclose pre.
  4. Run docclose pc.
  5. Run ordprg.pc.

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