Forms 12c: FRM-40350 Query Caused No Records To Be Retrieved (Doc ID 2156267.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Forms - Version 12.2.1.0.0 and later
Generic UNIX

Symptoms

Using Forms 12.2.1, calling a form from a menu or a button generates: FRM-40350 Query caused no records to be retrieved


ERROR
-----------------------
FRM-40350: Query caused no records to be retrieved


BEHAVIOR
-----------------------
The issue can be reproduced at will with the following steps:
- form that does a simple query from the database to populate some rows - works fine
- call the same form from a menu (eg with a button to invoke) - FRM-40350 generated

- another scenario: Using a form that contains a Pre-form trigger with a null and a When-New-Form-Instance trigger that contains a select statement that returns no records.

When the form runs and executes a query, error FRM-40350 is generated. Removing the triggers leads to the forms working ok.

Changes

 upgraded to Forms 12c

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