My Oracle Support Banner

Fcthreadexec Performance Problem When Processing Deals (Doc ID 2824832.1)

Last updated on NOVEMBER 30, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.


Following issue exists regardless of volume.
The fcthreadexec batch program has a performance problem when processing Deal Cost Events. The multi-table INSERT statement in the FUTURE_COST_THREAD_SQL. GET_ITEMLOC_DEAL is the reason for poor performance. Note that the FUTURE_COST table is growing steadily each day.

Steps to recreate: (During execution of an RMS batch process)
1) Set fcthreadexec to be multi-threaded (i.e. 16 threads)
2) Create 100+ off invoice deals (single item is ok), along with New Item/Locations, cost Changes, etc.
3) Run fcthreadexec
4) Notice batch is slow and doesn't complete.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.