Fusion Global Payroll: Archive Periodic Payroll Results Process is Failing With ' A system error ORA-01722: invalid number ORA-06512: at "SYS.DBMS_SQL", line 1712 ORA-06512: at "FUSION.PAY_REPORT_GENERIC" ' (Doc ID 2725381.1)

Last updated on NOVEMBER 02, 2020

Applies to:

Symptoms

On : 11.13.20.07.0 version, Global Payroll

When attempting to run Archive Periodic Payroll Results,
the following error occurs.

ERROR
-----------------------
A system error ORA-01722: invalid number ORA-06512: at "SYS.DBMS_SQL", line 1712 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 711 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2080 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1969 O
ORA-01722: invalid number ORA-06512: at "SYS.DBMS_SQL", line 1712 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 711 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2080 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1969 ORA-06512: at li
A system error occurred during processing. Contact your help desk

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run Archive Periodic Payroll Results,
2. error occurs.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.