Fcosttmplupld Batch Performance Issue
(Doc ID 3050994.1)
Last updated on OCTOBER 01, 2024
Applies to:
Oracle Retail Merchandising System - Version 16.0.2 and laterInformation in this document applies to any platform.
Symptoms
On : 16.0.3 version, Batches
ACTUAL BEHAVIOR
---------------
fcosttmplupld Batch performance issue
It is observed that fcosttmplupld batch is running longer when it is required to process about 2000 items. There is an SQL in the batch which has coding that results in Oracle optimizer using Cartesian join.
As a workaround files need to be broken into small files and processed.
EXPECTED BEHAVIOR
-----------------------
The fcosttmplupld batch should be optimised to run with more than 2000 items
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run fcosttmplupld Batch processing over 2000 items
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process over 2000 items at once
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 |