My Oracle Support Banner

Peformance Management Home Page ORA-06512: At "APPS.HR_UTIL_MISC_SS", Line 2685 (Doc ID 2571955.1)

Last updated on MAY 28, 2021

Applies to:

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


On : 12.2.4 version, Appraisals

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

Manager has global name with more then 100 characters (Arabic characters included)

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
  ,decode(t.effective_date_option, 'A', 'A', 'E') date_switch
  ,decode(hr_transaction_swi.isEditAllowed(t.transaction_id, t.status, null, 0, :1, :2, 0),'Y','EditEnabled','EditDisabled') editAllowed
  ,decode(hr_transaction_swi.isDeleteAllowed(t.transaction_id, t.status, null, 0, 0),'Y','DeleteEnabled','DeleteDisabled') deleteAllowed
## 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 2685

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(

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

1. Trying to launch the Performance Management Page

The above error raises.




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.