Performance Delay Due to Large Amount of Duplicate Data in AS_ITM_STRC_ASC Table
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.
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.
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