Fusion Global HR: Performance issue with Extracts
(Doc ID 3009404.1)
Last updated on MARCH 16, 2024
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.24.01.0 and laterInformation in this document applies to any platform.
Symptoms
HCM extracts are running slow and failing with following error in a log file.
ERROR
Error Messages
A system error occurred during processing. Contact your help desk.
ORA-01555: snapshot too old: rollback segment number XXX with the name "_SYSSMU281_1019914833$" too small ORA-06512: at "SYS.DBMS_SQL", line 1726 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 714 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2244 ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2100 ORA-06512: at line 1
A system error ORA-01555: snapshot too old: rollback segment number XXX with name "_SYSSMU281_1019914833$" too small ORA-06512: at "SYS.DBMS_SQL", line 1726 ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 714 ORA-06512: at "FUSION.PAY_REPOR
STEPS
The issue can be reproduced at will with the following steps:
1. Data Exchange > Run Extract
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 |
Cause |
Solution |