My Oracle Support Banner

FCEXEC Has Performance Issue While Merging Data In GTT_FC_ITEM_EXP_DETAIL Table (Doc ID 3010475.1)

Last updated on MARCH 15, 2024

Applies to:

Oracle Retail Merchandising System - Version 15.0.3 to 15.0.3 [Release 15.0]
Information in this document applies to any platform.

Symptoms

FCEXEC has performance issues while merging data in GTT_FC_ITEM_EXP_DETAIL table.

Steps to reproduce:

1. Process new item loc messages from integration layer.
2. Total number of new item loc messages should be more than ~300K
3. Execute FCEXEC batch
4. Batch is running for 3 hour 32 minutes

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.