Performance Issue On Item Induction On CFA Processing
(Doc ID 3007096.1)
Last updated on FEBRUARY 28, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 to 24.0 [Release 23.1 to 24.0]Information in this document applies to any platform.
Symptoms
Customer has a use case for uploading large volumes of item CFA updates twice a year using a custom item maintenance template.
In tests with different volumes, updates with up to 1000 items are processed relatively quickly, but updates with 1000 items or more on the upload template are taking excessively long, out of proportion to the number of items:
100 items - ~1 second
500 items - ~2 seconds
1000 items - 12 to 17 minutes
2000 items - 2 hours plus
Expectation: item upload for large volumes does not run so disproportionately slowly, especially given that the template is only updating single values in one table (ITEM_MASTER_CFA_EXT).
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 |