Interface Extract Error (Doc ID 2034291.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Absence Management Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Global Human Resources

HCM extract fails with below error


ERROR
-----------------------
PAY_PAYPROC_UNKNOWN_ERR
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SQL", line 1854
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 715
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1823
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1426
ORA-06512: at line 1

Token3 20
HR_6881_HRPROC_ORA_ERR
Name null
Token1 null
Token2 null
Token3 null
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SQL", line 1854
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 715
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1823
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1426


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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot submit the interface file to the payroll EBS system. This is an urgent issue.

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