My Oracle Support Banner

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.


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).


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.