Errors Generated When Compiling Service Forms & Library Files After Upgrade to Release 12.1.3

(Doc ID 1341204.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:CSXSRISR.FMB - Create Service Requests

Goal

Why are the Service forms & library files not compiling successfully after upgrading to Release 12.1.3 ?

CSXSRISR.fmx
CSSRWKB.plx
CSSRTAB.plx
CSSRISR.plx


Errors:

CSXSRISR_US.err
..
Compiling package body APP_CUSTOM...
Compilation error on package body APP_CUSTOM:
PL/SQL ERROR 49 at line 73, column 12
bad bind variable 'dup_check.dup_rec'
PL/SQL ERROR 49 at line 73, column 12
bad bind variable 'dup_check.dup_rec'
..
Compiling procedure JTF_CUSTOM_GRID_EVENT...
Compilation error on procedure JTF_CUSTOM_GRID_EVENT:
PL/SQL ERROR 49 at line 107, column 7
bad bind variable 'parameter.find_screen_name'
PL/SQL ERROR 49 at line 107, column 7
bad bind variable 'parameter.find_screen_name'
PL/SQL ERROR 49 at line 115, column 10
bad bind variable 'parameter.ib_called_from'
PL/SQL ERROR 49 at line 115, column 10
bad bind variable 'parameter.ib_called_from'
PL/SQL ERROR 49 at line 141, column 12
bad bind variable 'parameter.Ib_called_from'
PL/SQL ERROR 49 at line 141, column 12
bad bind variable 'parameter.Ib_called_from'
PL/SQL ERROR 49 at line 151, column 20
bad bind variable 'parameter.find_incident_number'
PL/SQL ERROR 49 at line 151, column 20
bad bind variable 'parameter.find_incident_number'
..

CSSRWKB.err

.
Compiling Package Body WKB_GRID_CONTROL......
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 0 at line 324, column 6
Statement ignored
Closing library CSSRWKB...
Compilation errors on CSC_PLAN_OUTCOMES:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 21, column 4
Declaration ignored
PL/SQL ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
..

CSSRTAB.err

..
Compiling Package Body SERVICE_HISTORY_LIB......
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 0 at line 468, column 7
Statement ignored
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 0 at line 566, column 11
Statement ignored
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 21, column 4
Declaration ignored
ERROR 0 at line 0, column 0
Automatic recompile of Package Spec CSC_PLAN_OUTCOMES failed
ERROR 0 at line 583, column 11
Statement ignored
..

CSSRISR.err

..
Compiling Package Body INC_TRACKING_CUST_PLAN......
ERROR 801 at line 0, column 0
internal error [60603]
ERROR 0 at line 3, column 3
Item ignored
ERROR 311 at line 4, column 20
the declaration of "G_MSG_TAB_TYPE" is incomplete or malformed
ERROR 0 at line 4, column 20
Item ignored
ERROR 311 at line 25, column 47
the declaration of "G_MSG_TAB_TYPE" is incomplete or malformed
ERROR 0 at line 25, column 3
Item ignored
ERROR 320 at line 221, column 24
the declaration of the type of this expression is incomplete or malformed
ERROR 0 at line 221, column 7
Statement ignored
ERROR 320 at line 243, column 54
the declaration of the type of this expression is incomplete or malformed
ERROR 0 at line 237, column 7
Statement ignored
Compiling Package Body INC_TRACKING_CUST_FIELDS_PVT......
Compiling Package Body INC_TRACKING_CUST_FIELDS......
ERROR 801 at line 0, column 0
..
Compiling Package Body BILL_TO_SHIP_TO_ADDRESS......
Closing library CSSRISR...
Compilation errors on FIRE_RELATIONSHIP_PLANS:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 5, column 25
Declaration ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 6, column 25
Declaration ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 8, column 4
Declaration ignored
PL/SQL ERROR 0 at line 0, column 0
Automatic recompile of Package Spec FIRE_RELATIONSHIP_PLANS failed


Compilation errors on INC_TRACKING_CUST_PLAN:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 3, column 3
Item ignored
PL/SQL ERROR 311 at line 4, column 20
the declaration of "G_MSG_TAB_TYPE" is incomplete or malformed
PL/SQL ERROR 0 at line 4, column 20
Item ignored
PL/SQL ERROR 311 at line 25, column 47
the declaration of "G_MSG_TAB_TYPE" is incomplete or malformed
PL/SQL ERROR 0 at line 25, column 3
Item ignored
PL/SQL ERROR 320 at line 221, column 24
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 221, column 7
Statement ignored
PL/SQL ERROR 320 at line 243, column 54
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 237, column 7
Statement ignored


Compilation errors on INC_TRACKING_CUST_FIELDS:
PL/SQL ERROR 0 at line 412, column 9
Statement ignored
PL/SQL ERROR 0 at line 796, column 9
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.





Solution

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