My Oracle Support Banner

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.

Symptoms

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:

  1. Create cost events (NIL, R, SC) that will result in 30+ million future cost records getting created.
  2. Run FCTHREADEXEC.
  3. Run PREPOST FCEXEC PRE.
  4. Run FCEXEC.

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.