Unable To Add Item In ASCP Planning Workbench When Item List > FORMS_RECORD_GROUP_MAX Environment Variable (Doc ID 2294933.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.9.1

Unable to add Item in ASCP Planning Workbench

When we are trying to add one new records in ASCP planning Workbench that LOV shows maximum 25000 rows only.
When we are putting some condition also for search still we are not able to find the items which are not there in original list of 25000
This is happening for multiple items.


When we are finding this items in planning workbench we are able to see that item.
When we are trying to add new row for the items which is not there in first 25000 list of items alphabetically it is not taking that item.
If you put any other items which is there below in those 25000 items list value it is getting added.

If we are putting any search criteria then also it is finding list of items within that 25000 list of item.

"Choices in list, limited by maximum rows: 25000"

Similar to other issues with Find window and need to use filter_before_display to allow users to find items and for the validation of items when partial or full item name is entered on the new planned order line.

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