Applying ASCP Cumulative Update Patch Fails Compiling MSCOSCW1.pls With PL/SQL ERROR 302 component 'GET_SCHEMA_NAME' must be declared (Doc ID 3045229.1)

Last updated on SEPTEMBER 02, 2024

Applies to:

Symptoms

While applying the cumulative patch outlined in Note 1361221.1, the following error occurred:

ERROR
-----------------------
Generating library "resource/MSCOSCW1.plx" with command:

/hol/apsd/apps/fs1/EBSapps/10.1.2/bin/frmcmp_batch module=/hol/apsd/apps/fs1/EBSapps/appl/au/12.0.0/resource/MSCOSCW1.pll output_file=/hol/apsd/apps/fs1/EBSapps/appl/au/12.0.0/resource/MSCOSCW1.plx module_type=library batch=yes compile_all=special

ERROR generating library "resource/MSCOSCW1.plx" from input file
/hol/apsd/apps/fs1/EBSapps/appl/au/12.0.0/resource/MSCOSCW1.pll

Results of library generation:
(from file /hol/apsd/apps/fs1/EBSapps/appl/au/12.0.0/resource/MSCOSCW1.err
 AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on MSCOSCWB:
PL/SQL ERROR 302 at line 13, column 44
component 'GET_SCHEMA_NAME' must be declared
PL/SQL ERROR 0 at line 13, column 8
Declaration ignored
PL/SQL ERROR 302 at line 14, column 44
component 'GET_SCHEMA_NAME' must be declared
PL/SQL ERROR 0 at line 14, column 17
Declaration ignored
PL/SQL ERROR 0 at line 0, column 0
Automatic recompile of Package Spec MSCOSCWB failed

Compilation errors on MSCOSCWB:
PL/SQL ERROR 0 at line 0, column 0
Compilation unit analysis terminated

Compilation errors on MSCBALWB:
PL/SQL ERROR 0 at line 31, column 2
Statement ignored

Compilation errors on LINES:
PL/SQL ERROR 0 at line 102, column 2
Statement ignored
PL/SQL ERROR 0 at line 152, column 7
Statement ignored
PL/SQL ERROR 0 at line 795, column 1
Statement ignored

Compilation errors on CONTROL:
PL/SQL ERROR 0 at line 97, column 16
Statement ignored
PL/SQL ERROR 0 at line 177, column 8
Statement ignored
PL/SQL ERROR 0 at line 181, column 16
Statement ignored
PL/SQL ERROR 0 at line 212, column 13
Statement ignored
PL/SQL ERROR 0 at line 259, column 8
Statement ignored
PL/SQL ERROR 0 at line 309, column 11
Statement ignored
PL/SQL ERROR 0 at line 386, column 3
Statement ignored
PL/SQL ERROR 0 at line 395, column 3
Statement ignored
PL/SQL ERROR 0 at line 587, column 3
Statement ignored

Compilation errors on ATP_SOURCES:
PL/SQL ERROR 0 at line 13, column 9
Statement ignored

Compilation errors on ATP_INV:
PL/SQL ERROR 0 at line 43, column 10
Statement ignored
PL/SQL ERROR 0 at line 60, column 8
Statement ignored
PL/SQL ERROR 0 at line 98, column 10
Statement ignored
PL/SQL ERROR 0 at line 223, column 2
Statement ignored
PL/SQL ERROR 0 at line 254, column 12
Statement ignored
PL/SQL ERROR 0 at line 324, column 6
Statement ignored

Compilation errors on APP_CUSTOM:
PL/SQL ERROR 0 at line 162, column 5
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.


The issue can be reproduced at will with the following steps:
1.  Apply the latest CU patch as outlined in Note 1361221.1.  This can be any CU patch for a release greater than 12.2.6.3.

Cause

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