R12 PAXSUDEV: Event Type Form Gives FRM:40735: ON-INSERT Trigger Raised Unhandled Exception ORA-04062 (Doc ID 2031903.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Event type (PAXSUDEV) form gives the following when trying to update it:

FRM:40735: ON-INSERT trigger raised unhandled exception ORA-04062

Manual compilation resulted in error:

Compiling ON-UPDATE trigger on EVENT_TYPES data block...
 No compilation errors.

Compiling PRE-QUERY trigger on EVENT_TYPES data block...
Compilation error on PRE-QUERY trigger on EVENT_TYPES data block:
PL/SQL ERROR 49 at line 3, column 4
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 4
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 5, column 3
bad bind variable 'parameter.G_query_find'

Compiling QUERY_FIND trigger on EVENT_TYPES data block...
 No compilation errors.
...
Compiling WHEN-BUTTON-PRESSED trigger on OUTPUT_TAX_BUT item in CONTROL_BLK data block...
Compilation error on WHEN-BUTTON-PRESSED trigger on OUTPUT_TAX_BUT item in CONTROL_BLK data block:
PL/SQL ERROR 49 at line 4, column 3
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 4, column 3
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 6, column 3
bad bind variable 'parameter.G_query_find'

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