My Oracle Support Banner

R12: GLLEZL ORA-00060 WHEN RUN IN PARALLEL FOR GAPLESS SEQUENCE (Doc ID 1394405.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run journal import at the exact same time for the same
journal source but different group_id, one import fails with
the following error:

ERROR
-----------------------
Erreur ORACLE -60 dans get_next_user_sequence.
Cause : L'exécution de la routine get_next_user_sequence a échoué en raison
de ORA-00060: détection d'interblocage pendant l'attente d'une ressource.
L'instruction SQL qui était en cour
<x gluseq() 04-OCT-2010 20:11:11
<x gllseq() 04-OCT-2010 20:11:11

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
References


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