Error: ORA-00060 When Journal Import Is Submitted In Parrallel For Multiple Ledgers

(Doc ID 2350637.1)

Last updated on JANUARY 26, 2018

Applies to:

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

Symptoms

Using custom process to load data into GL_INTERFACE. Then update both GL_INTERFACE and GL_INTERFACE_CONTROL tables with custom script.
Submit journal import from GL form itself and the Log shows:

Journal Import is submitted in parallel for multiple ledgers for user je source and this is not related to customization. Requirement is to be able to process multiple ledgers in parallel without deadlocks rather than running for more ledgers in serial.

Changes

None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms