Runtime Error FRM-40815 and FRM-40105 In Form Calling an LOV Form (Doc ID 262573.1)

Last updated on JULY 03, 2023

Applies to:

Symptoms

The Forms generator can generate forms called LOV Forms.
An LOV form is a query-only form that acts as an alternative to the native Oracle Forms LOV to display lists of valid values.
An LOV form is called from another form, via a KEY-LISTVAL trigger.
When the user presses 'Commit' in the LOV form, the value of the Primary Key of the current record in the LOV Form is saved in a GLOBAL variable, so that the calling form can change the values of the corresponding lookup fields.

This works fine when the bound items of the calling module and the LOV module are the same as the database columns.
However, when they are different, the COMMIT in the LOV form raises the following error:

   FRM-40105: Unable to resolve reference to item DEPT_MC.DEPTNO

and the following error in the calling form:

   FRM-40815: Variable GLOBAL.CGFL$DEPTNO_BASE_BI does not exist

The row that was selected in the LOV is not passed to the calling module.

Changes

The problem occurred after you upgraded to Designer 6i Release 4.9 or Designer 9i Release 9.0.2.7
Problem did not occur in previous releases.

Cause

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