My Oracle Support Banner

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.

Symptoms

After upgrade to 12.2.10 RUP 14 when manager attempt to provide comment for appraisal final rating
the following error occurs.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package hr_assessments_swi Procedure update_assessment


STEPS
-----------------------
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

Changes

 Upgrade to 12.2.10 RUP 14

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


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