My Oracle Support Banner

Run Year to Date Reconciliation Report Returns ORA-06512: at "SYS.DBMS_SQL", line 1707 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2030 (Doc ID 2573514.1)

Last updated on OCTOBER 17, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.10.0 and later
Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

A payroll flow has been submitted which runs the seeded "Run Year to Date Reconciliation Report" in /Human Capital Management/Payroll/Regulatory and Tax Reporting/UK/RTI Reconciliation.xdo

However, when clicking on 'ok and view checklist', the status shows the following errors:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "FUSION.HRX_GB_RTI_RECON", line 782 ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1707 ORA-06512: at

"FUSION.PAY_REPORT_PROCESS", line 2030

and

A system error ORA-06502: PL/SQL: numeric or value error: character string

buffer too small ORA-06512: at "FUSION.HRX_GB_RTI_RECON", line 782 ORA-06512:

at line 1 ORA-06512: at "SYS.DBMS_SQL", line 1707 ORA-06512: at "FUSION.PAY_REPORT_PROC

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.