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 laterInformation in this document applies to any platform.
Symptoms
PROBLEM
-------------
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
STEPS
--------
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
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |