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 AUGUST 02, 2019

Applies to:

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

Symptoms

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)

ERROR
-----------------------
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
  ,nvl(hr_general.decode_lookup('PQH_
...
...
....
## 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(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
....



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

1. Trying to launch the Performance Management Page

The above error raises.


Changes

 

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.