Performance Issue With Future Cost Event Execute (FCEXEC) Batch

(Doc ID 1500719.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle Retail Merchandising System - Version 13.1.4.4 and later
Information in this document applies to any platform.
Checked for the relevance of the document as on 8th Dec,2014.

Symptoms

There is a performance issue with the Future Cost Event Execute (FCEXEC) batch. The batch takes more than 20 minutes to complete.


Steps to Recreate:

  1. Create and approve a new item and associate locations to it.

  2. Edit the item and add Estimated Landed Cost (ELC) components to it.

  3. Ensure that there are rows in the COST_EVENT_ELC table for the item.

  4. Run future cost batches as follows:

    a. FCTHREADEXEC
    b. PREPOST FCEXEC PRE
    c. FCEXEC

  5. Notice that the batch FCEXEC takes a very long time to complete.



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