My Oracle Support Banner

There is a Record Count Limit in the Planners Workbench / Resources View - Select More Than 94 Rows and Get Error - ORA-01403: no data found (Doc ID 2858908.1)

Last updated on MARCH 30, 2022

Applies to:

Oracle Materials Requirement Planning - Version 12.2.6 and later
Information in this document applies to any platform.


Cannot use resource view and pull up supplies when records selected exceeds 94.
Get error ORA-01403: no data found
FRM-40735: FIND trigger raised unhandled exception ORA-06502

In workbench - choose resources
Find -- Department - equals - ASSEMBLY
Click Resource Requirements
Check box to highlight rows, scroll down and click more rows.. repeat
Then click Supply
Supply results appear if less than 94 rows - but fails when more than 94


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.