Fusion PIM: ADFDI Import Excel Errors on Open Because of an LOV With Too Many Values (Doc ID 2102977.1)

Last updated on MARCH 11, 2016

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Import Items

Excel errors out at the open because there is a LOV with too many values

Define an extensible attribute with a LOV and the Attribute Display Type = Drop Down List

User downloads the Excel template in order to upload items in the "Manage Item Batch" functionality.
At the opening of the Excel file, it occurs the error: ADFDI-05539: unable to initialize worksheet: Items

EFF attribute LOV contains too many values. and for business reasons is composed of 38000 records.

ERROR
-----------------------
ADFDI-05539

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create EFF and value set with 38k values.
2. Manage Items
3. Perform Mass Updates



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