My Oracle Support Banner

Troubleshooting: FRM-40301 (Doc ID 15812.1)

Last updated on DECEMBER 08, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


The message "FRM-40301: Query Caused No Records to be Retrieved" is usually very straightforward, indicating that there are no matching records for the query criteria. Occasionally, though, this message comes up even if the query returns rows in SQL*Plus or if a blind query is performed. The cause of the error in these cases is much harder to determine.
This bulletin is a step-by-step guide to debugging and resolving such situations when they occur in Oracle Forms.

Troubleshooting Steps

To view full details, 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 a vibrant support community of peers and Oracle experts.