MERCHAPI_REFRESH_ADHOC_PROCESS Is Extremely Slow In Loading Items Json Table (merchapi_ext_item)
(Doc ID 3015908.1)
Last updated on APRIL 12, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 to 24.0 [Release 24.0]Information in this document applies to any platform.
Goal
MERCHAPI_REFRESH_ADHOC_PROCESS is extremely slow in loading Items json table (merchapi_ext_item)
Facing performance issues initializing the MERCHAPI_EXT_ITEM json store table using the MERCHAPI_REFRESH_ADHOC_PROCESS.
Post data conversion, the foundation/item service was enabled and MERCHAPI_REFRESH_ADHOC_PROCESS was run. The MERCHAPI_REFRESH_ADHOC_PROCESS runs more than 6 hours and loads only 8000 records in each run. The number of records in item_master are 3797477 (includes all level items) which is not a high volume. At this rate, it will take months before the json store is initialized.
Solution
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
Goal |
Solution |
References |