CSCHTAB.pll , CSSRTSK.pll and OKSACTEV.pll Do Not Generate Successfully After Patch Application (Doc ID 2007657.1)

Last updated on AUGUST 15, 2023

Applies to:

Symptoms

After applying patches on top of 12.2.4 there are errors compiling certain libraries and forms:

The following Oracle Forms objects did not generate successfully:
au resource CSCHTAB.pll (version: 120.122.12020000.28)
au resource CSSRTSK.pll (version: 120.204.12020000.39)
au resource OKSACTEV.pll (version: 120.4.12020000.3)

CSCHTAB.pll (120.122.12020000.28)
   Compilation errors on CHARGE_BUTTONS:
   PL/SQL ERROR 907 at line 0, column 0
   cannot load library unit APPS.CS_CHARGE_DETAILS_PUB (referenced by APPS.CSD_PROCESS_UTIL)
   PL/SQL ERROR 0 at line 671, column 32
   Item ignored
   PL/SQL ERROR 320 at line 675, column 4
   the declaration of the type of this expression is incomplete or malformed
   PL/SQL ERROR 0 at line 675, column 4
   Statement ignored
   PL/SQL ERROR 320 at line 676, column 4
   the declaration of the type of this expression is incomplete or malformed
   PL/SQL ERROR 0 at line 676, column 4
   Statement ignored
   PL/SQL ERROR 320 at line 677, column 4
   the declaration of the type of this expression is incomplete or malformed
   PL/SQL ERROR 0 at line 677, column 4
   Statement ignored
   PL/SQL ERROR 320 at line 685, column 10
   the declaration of the type of this expression is incomplete or malformed
   PL/SQL ERROR 0 at line 685, column 6
   Statement ignored
   
   Failed to generate library.
   
   FRM-30312: Failed to compile the library.
   
CSSRTSK.pll (120.204.12020000.39)
   Compilation errors on MULTIPLE_TIME_ZONE_SUPPORT:
   PL/SQL ERROR 302 at line 2290, column 31
   component 'CS_TIMEZONE_TZ' must be declared
   PL/SQL ERROR 0 at line 2290, column 10
   Statement ignored
   PL/SQL ERROR 302 at line 2291, column 28
   component 'CS_TIMEZONE_TZ' must be declared
   PL/SQL ERROR 0 at line 2291, column 9
   Statement ignored
   
   Failed to generate library.
   
   FRM-30312: Failed to compile the library.
   
OKSACTEV.pll   (120.4.12020000.3)
   Compilation errors on OKSACTEV_COUNTERS_EVENTS:
   PL/SQL ERROR 907 at line 0, column 0
   cannot load library unit APPS.CS_STD (referenced by APPS.CS_COUNTERS_PUB)
   PL/SQL ERROR 0 at line 109, column 4
   Statement ignored
   
   Failed to generate library.
   
   FRM-30312: Failed to compile the library.

Changes

 Applied 12.2.4 patches.

Cause

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