My Oracle Support Banner

FCDB Purge Job "JB_ADM_PURGE_TIMEOUT_USERSESN" Fails With Error "ORA-01001: invalid cursor" Found in Database Trace Logs (Doc ID 2528973.1)

Last updated on OCTOBER 16, 2019

Applies to:

Oracle FLEXCUBE Direct Banking - Version DB 12.0.2 to DB 12.0.3 [Release DB 12]
Information in this document applies to any platform.

Symptoms

FCDB (Oracle FLEXCUBE Direct Banking) Purge Job - JB_ADM_PURGE_TIMEOUT_USERSESN fails during execution with error"ORA-01001: invalid cursor".

Below Error is observed in FCDB database trace logs :
------------------------------------
ORA-12012: error on auto execute of job "FCDBADMIN_PROD"."JB_ADM_PURGE_TIMEOUT_USERSESN"
ORA-01001: invalid cursor
ORA-06512: at "FCDBADMIN_PROD.PURGE_USERSESSION", line 31
ORA-06512: at line 2

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.