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

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version 6.5.94 to 9.0.4.4 [Release Designer 6i to Designer 10g]
Information in this document applies to any platform.
"Checked for relevance on 13-Aug-2014"


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

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