Performance Management Function Errors - ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2107349.1)

Last updated on MAY 16, 2016

Applies to:

Oracle Performance Management - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.

Symptoms

On 12.1 HRMS RUP 5 version of Application, In the Performance Management Page

When attempting to Launch the Performance Management Page, the following Error and Exception Log is thrown

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Exception Log:
---------------------

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hr_sflutil_ss.GETSUBJECT(t.transaction_id, null) subject, 'SubjectText' subjectSwitch
  ,to_number(null) notification_id, t.transaction_id, t.creator_person_id, t.selected_person_id
  ,nvl(t.product_code, 'PER') product_code, t.function_id, t.transaction_ref_table, t.transaction_ref_id, t.transaction_type
  ,t.item_type, t.transaction_group, t.transaction_identifier
  ,decode(t.effective_date_option, 'A', trunc(sysdate), t.transaction_effective_date) effective_date

..........

........................

## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 2268

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Login to 'Manager Self-Service' Responsibility.

2. Navigate to function 'Performance Management'.

3. When tried to launch the same got the above error message and the Exception Log.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms