My Oracle Support Banner

Getting Error "bad bind variable 'parameter.nri_parameter'' When Compiling CSDREPLN.fmb (Doc ID 2816686.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Oracle Depot Repair - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

In 12.2.9 version, Patch Application Issues

ACTUAL BEHAVIOR
---------------
The following Oracle Forms objects did not generate successfully when applying patch 31818592:R12.SCM_PF.C

csd forms/US CSDREPLN.fmx

The following errors were observed during compilation:

 

Compiling KEY-HELP trigger on form...
Compilation error on KEY-HELP trigger on form:
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling KEY-CLRFRM trigger on form...
Compilation error on KEY-CLRFRM trigger on form:
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-FORM trigger on form...
Compilation error on PRE-FORM trigger on form:
PL/SQL ERROR 0 at line 17, column 1
Statement ignored
PL/SQL ERROR 306 at line 20, column 1
wrong number or types of arguments in call to 'EVENT'
PL/SQL ERROR 0 at line 20, column 1
Statement ignored

Compiling WHEN-NEW-FORM-INSTANCE trigger on form...
Compilation error on WHEN-NEW-FORM-INSTANCE trigger on form:
PL/SQL ERROR 0 at line 3, column 1
Statement ignored

Compiling WHEN-NEW-ITEM-INSTANCE trigger on form...
Compilation error on WHEN-NEW-ITEM-INSTANCE trigger on form:
PL/SQL ERROR 0 at line 24, column 1
Statement ignored

Compiling WHEN-WINDOW-ACTIVATED trigger on form...
Compilation error on WHEN-WINDOW-ACTIVATED trigger on form:
PL/SQL ERROR 49 at line 3, column 7
bad bind variable 'parameter.nri_parameter'
PL/SQL ERROR 49 at line 3, column 7
bad bind variable 'parameter.nri_parameter'
PL/SQL ERROR 49 at line 5, column 3
bad bind variable 'parameter.nri_parameter'

EXPECTED BEHAVIOR
-----------------------
Forms would compile

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 31818592:R12.SCM_PF.C

2. Check the adpatch log for forms compilation 

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
  


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