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 laterInformation in this document applies to any platform.
Symptoms
While applying Patch 33154541(ORACLE APPLICATIONS RELEASE 12.1: CPU PATCH FOR OCT 2021), seeing the below error:
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |