Limitation On Number Or Records In AMONG Conditions In ASCP Search Screen (Doc ID 1560140.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Navigation: ASCP Workbench>Select plan>Select an org>right click >Supply and Demand>Supply and Demand. It opens a Find screen. Enter criteria as 'Item' . Condition as 'AMONG'. Another screen by name 'Among' opens prompting to enter the records. Use about 150 items in the "among" filter and hit find throws error:

FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

or if using a folder query FRM-40735:Folder_RETURN_ACTION trigger raised unhandled exception ORA-06502

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