Fusion UK Payroll - EPS Error - The dynamic SQL for a database item failed. Details: Context at the time of error: ORA-01555: snapshot too old: rollback segment number 250 with name too small (Doc ID 2942939.1)

Last updated on MAY 05, 2023

Applies to:

Symptoms

On : 11.13.23.01.0 version, Global Payroll

When attempting to run Employment Payment Submission (EPS), the following error occurs:

ERROR
-----------------------
ORA-20001: A system error ORA-20001: The dynamic SQL for a database item failed. Details: Context at the time of error: ORA-01555: snapshot too old: rollback segment number 250 with name "_SYSSMU250_1120232984$" too small.
ORA-06512: at "FUSION.PAY_R
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2178
ORA-06512: at "FUSION.HRX_GB_EPS_ARCH", line 72
ORA-06512: at "FUSION.HRX_GB_EPS_ARCH_2022", line 112
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 629
ORA-06512: at "FUSION.HRX_GB_EPS_ARCH_2022", line 101
ORA-06512: at "FUSION.HRX_GB_EPS_ARCH", line 65
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2159
ORA-06512: at line 1

Out } PayUtils.getActionParameter.returnValue
Out } PayUtils.getActionParameter
Name PAY_PAYPROC_UNKNOWN_ERR
Token1 null
Token2 null
Token3 null
A system error occurred during processing. Contact your help desk.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run EPS process in Live mode.
2. Run Employer Payment Summary task completes with an error.

Changes

Cause

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