INCOIN - Item Import Is Running Gather Statistics Producing Sometimes Bad Performance

(Doc ID 848617.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Item Master - Version: 11.5.10.0 to 11.5.10.0 - Release: 11.5 to 11.5
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
Find the performance of Import Items (INCOIN)  is gathering statistics automatically and there is no option avoid this happens. This is producing sometimes bad performance.

EXPECTED BEHAVIOR
Expect the program does not gather statistics if user does not request it.

STEPS
The issue can be reproduced at will with the following steps:
1. Populate data into Item Interface tables
2. Run Item Import (Inventory Responsibility => Items/Item Import)

 

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