My Oracle Support Banner

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


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