Fusion PIM: ADFDI Import Excel Errors on Open Because of an LOV With Too Many Values
Last updated on MARCH 11, 2016
Applies to:Oracle Fusion Product Hub Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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.
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
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