When Manager Attempt To Provide Comment for Appraisal Final Rating Error Is Raised Ora-06502: Pl/SQL: Numeric or Value Error: Character String Buffer Too Small in Package Hr_assessments_swi Procedure Update_assessment
(Doc ID 2833378.1)
Last updated on JANUARY 12, 2022
Applies to:Oracle Performance Management - Version 12.2.1 and later
Information in this document applies to any platform.
After upgrade to 12.2.10 RUP 14 when manager attempt to provide comment for appraisal final rating
the following error occurs.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package hr_assessments_swi Procedure update_assessment
The issue can be reproduced at will with the following steps:
1. (N) XX Manager Self-Service responsibility -> Performance Management > Appraisal
2. Click on Update Appraisal -> Go to Provide Overall Rating
3. Enter comment (around 2000 characters)-> click on Apply -> error is raised in self-service page
Upgrade to 12.2.10 RUP 14
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