My Oracle Support Banner

Clarification Regarding Deferring Sync Of Item Text Index (Doc ID 2784602.1)

Last updated on JUNE 15, 2021

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

As described in Oracle Doc ID 1208945.1

Deferring Sync of Item Text Index
The ICI program synchronizes the Item Text Index (used for item simple searches) with the latest item information after creating/updating items. This process has contention issues when executed in parallel across multiple concurrent programs. For initial data load scenarios, where you do not expect other users to search for items at that time, Oracle recommends that you customize the product code to comment the call to sync index, and do the same manually after each set of parallel threads are completed. To perform this customization:

In INVPOPIF, comment call to INV_ITEM_PVT.SYNC_IM_INDEX.
Run your data load batches.
After a set of parallel batches, call INV_ITEM_PVT.SYNC_IM_INDEX manually.
After you complete the data load process, uncomment the change you made in step 1.


Need to know the following
1. Users are using import item batch process continuously throughout the day. Is it ok to make changes to INVPOPIF by commenting call to INV_ITEM_PVT.SYNC_IM_INDEX and compiling it in the database?.
2. If the line suggested is commented, then which APIs will be impacted by it? Will it be only EGO_ITEM_PUB.Process_items for there are other APIs which might be impacted?
3. Need to understand how does INV_ITEM_PVT.SYNC_IM_INDEX work? If one calls it once every hour then will it sync all the create/update items with ICX done in last one hour irrespective of the number of import item batches that ran within 1 hour or do we need to call the API after each call to EGO_ITEM_PUB.Process_items?
 

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.