My Oracle Support Banner

Running The ESS Job 'Purge Contract Temporary Tables' Results In An Exception Error - ORA-01555: Snapshot Too Old (Doc ID 2954400.1)

Last updated on DECEMBER 07, 2023

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.23.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.23.01.0 version, File Import/Export

ACTUAL BEHAVIOR
-----------------------

ESS Job 'Purge Contract Temporary Tables' displaying the following error.

ERROR
-----------------------

ORA-01555: snapshot too old: rollback segment number 437 with name "_SYSSMU437_886850995$" too small
2000: Exception Leaving OKC_PURGE_DATA_PUB.PURGE_VALIDATE_CONTRACT
2000: Exception SQLCode=-1555 SQLErrM=ORA-01555: snapshot too old: rollback segment number 437 with name "_SYSSMU437_886850995$" too small

STEPS
-----------------------

1. Schedule ESS Job [Purge Contract Temporary Tables]
2. Complete ESS Job execution and download logs


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.