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.


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

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