My Oracle Support Banner

While applying Patch 33154541(12.1 CPU PATCH-OCT 2021) PERWSEMA.pll Compliation Error (Doc ID 2917201.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


While applying Patch 33154541(ORACLE APPLICATIONS RELEASE 12.1: CPU PATCH FOR OCT 2021), seeing the below error:

Compiling Package Body PERWSEMA_DELETE......
Compiling Package Body PERWSEMA_COMMON_COMMIT......
Compiling Package Body PERWSEMA_CAGR_PROCESS......
Compiling Package Body PERWSEMA_ASSGT_BLOCK2......
Compiling Package Body PERWSEMA_ASSGT_BLOCK......
Compiling Package Body PERWSEMA_APP_CUSTOM......
Compiling Procedure Body ASSGT_NAV......
Closing library PERWSEMA...

Compilation errors on PERWSEMA_PRE_UPDATE:
PL/SQL ERROR 363 at line 290, column 7
expression 'P_SESS_DATE' cannot be used as an assignment target
PL/SQL ERROR 0 at line 266, column 4
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

Steps to Replicate:
The issue can be reproduced at will with the following steps:
1. Apply Patch 33154541.
2. See patch failure.
3. Review patching logs for failure point.
      - See above error.




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

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