Performance Delay Due to Large Amount of Duplicate Data in AS_ITM_STRC_ASC Table (Doc ID 2204448.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Retail Central Office - Version 14.0.1 and later
Information in this document applies to any platform.

Symptoms

Duplicate data is inserted in AS_ITM_STRC_ASC table although "UPS" is used in item import DIMP.

Steps to Reproduce:

1. Process an item import with change type as ADD and check for entries in AS_ITM and AS_ITM_STRC_ASC.
2. Process second item import with change type as UPS.
3. Note that there exists one entry for an item in the AS_ITM table and 2 entries in the AS_ITM_STRC_ASC table for the same item, irrespective of change type.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms