My Oracle Support Banner

Greece Localization : CLE: Turnover Report XML error "ORACLE error 1555 in FDPSTP" (Doc ID 2547960.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

EMEA Add-on Localizations - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Reported Issue:-
------------------
Concurrent :CLE: Turnover Report XML is failing with an error .


Error observed
-------------------
**SQL error and free**22-JAN-2019 12:44:14
ORACLE error 1555 in FDPSTP

Cause: FDPSTP failed due to ORA-01555: snapshot too old: rollback segment number 1552 with name "_SYSSMU1552_735143637$" too small
ORA-06512: at "APPS.CLE_F118_TURNOVER_RPT_XML_PKG", line 803
ORA-06512: at line 1

Steps for replication
----------------------
1. Run concurrent "CLE: Turnover Report XML".
2. It is running for more than a day and finally completing with an error.

Expected Behavior
-------------------------
Concurrent should be allowed to complete without any errors.

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


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