Fusion Global HR: Update Person Search Keywords Results In Error (Doc ID 1608576.1)

Last updated on FEBRUARY 06, 2015

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Global Human Resources - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Update Person Search Keywords ends with a status of error:

[2013-12-12T22:58:32.734+00:00] [ess_server1] [ERROR] [ESS-07004] [oracle.as.ess] [tid: ESS Execute Thread [RequestId:3807]] [ecid: 004vLrOsbHO6IR73VJiOR80001nK000dFa,0:1:1:2:1:61:100001206] [APP: HcmEssApp#V2.0] [ESS_JobMetadataID: JobDefinition://oracle/apps/ess/hcm/person/search/PersonKeywordSearch] [ESS_RequestID: 3807] [ESS_Module: Processor] Execution error for request 3807. Reason: ESS-01708 Database job for request 3807 ended with error: SQL execution error. JobName: FUSION_RUNTIME.ESS1$JB_3807[[
--- SQL Execution Error ---
ErrorCode: 20979
ErrorMsg: [ORA-20979: Request 3807 encountered ERROR: ORA-20100: ORA-00600: internal error code, arguments: [723], [1052712], [pga heap], [], [], [], [], [], [], [], [], []
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-20100: ORA-00600: internal error code, arguments: [723], [1052712], [pga heap], [], [], [], [], [], [], [], [], []
ORA-06502: PL/SQL: numeric or value error: character string buffer too small while executing BEGIN PER_PERSON_KEYWORD_SEARCH.PERSON_TEXT_SEARCH_INCR(:errb]

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

1. Login as user with HR Administrator privileges
2. Navigate to Scheduled Processes
3. Run the Update Person Search Keywords process.
Observe that it finishes with Status = Error.



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