Performance Issue with FCEXEC Batch
(Doc ID 2784144.1)
Last updated on JUNE 25, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.
Performance issue while running future cost batches including NewItemloc(NIL),Recalssification(R),Supplier Cost change(SC).
For example, From the last run there were ~ 1.4 million new item/locations along with some item reclassifications added to the system during batch processing which in turn resulted in ~ 32 million records processed by the future cost batch.
The batch had 32 threads and took 5 hours 24 minutes to run.
Steps to Recreate:
- Create cost events (NIL, R, SC) that will result in 30+ million future cost records getting created.
- Run FCTHREADEXEC.
- Run PREPOST FCEXEC PRE.
- Run FCEXEC.
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