Valueset Of 1 Million Rows Will NOT Not Open From WEBADI (Works From PIM HTML User Interface)

(Doc ID 1953210.1)

Last updated on FEBRUARY 11, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Valueset opening fine from the PIM Oracle Application (OA) framework HTML User Interface (UI) but does not open from WEBADI.

The list of values shows blank for large lists in WebADI Excel.
The same list of values (LOV) works in the HTML user interface.

ERROR
The BNE Log shows a memory error:

EXPECTED BEHAVIOR
Expects Valueset to work in Webadi too.

STEPS
1. Create a table driven value-set with 1 million+ rows.
2. Access data via Webadi (Search on item in Development Manager > Simple Search > Choose display format to include column with value-set > Export to Excel)
3. Try to use List of values (LOV) in Excel.
4. The list shows blank.
* Also see error in BNE log file.

BUSINESS IMPACT
The business expects that as the LOV is working from the HTML User interface (UI) that it should work from WEBADI in Excel.
Moreover its a general business expectation that the number of rows in an LOV cannot be restricted.
This is working through 100,000 rows but not for 1 million rows.

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