Performance Issue With RMS Ordprg.pc (Order Purge) Batch
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 220.127.116.11 and later
Information in this document applies to any platform.
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.
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