HCM Extract Ends in Error ORA-06502 Buffer Too Small (Doc ID 1590143.1)

Last updated on SEPTEMBER 06, 2016

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

On : 11.1.5.0.0 version, Set Up Workforce Deployment-Define Extracts

When the HCM extract is run for only one employee,  Extract successfully generates the output. However, when it is run without Block Criteria, the following error is produced.


ERROR
-----------------------
Scheduled Process screen shows a failure, but not a specific error.

Log file shows the following:

" processing mode is ProcessRelAction
In { PayMessage.setMessageText

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 47
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1624
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1385
ORA-06512: at line 1 "


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Run the extract with the following details:

Extract Name : HCM Extract1
Extract Type : Full Profile
Legislative Data Group: None

This will fail.

2) Query the Extract definition to the Manage HCM Extracts and include a criteria to only run for one employee (i.e. PER_EXT_PER_PERSON_NUMBER = '233888'}
3) Run the extract with the same details:
Extract Name : HCM Extract1
Extract Type : Full Profile
Legislative Data Group: None

This will complete without error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the extract for multiple employees. .


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