EGL: Journal Generator Abends at Step GL_JPROC.DD810.INST_TMP with Unique Constraint on PS _GL_JCOBOL_TMP and Journal Edit Abends at Step GL_JPROC DD020 LOGLOCK with Unique Constraint on PS_JRNL_EDIT_LOG
Last updated on OCTOBER 16, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 8.8 to 9.1 [Release 8.8 to 9]
Information in this document applies to any platform.
*** checked for relevance 16-Oct-2017 ***
How to resolve Journal Generator or Journal Edit process that fails with a duplicate insert to temp/log tables, GL_JCOBOL_TMP or JRNL_EDIT_LOG (examples of errors listed below).
1:54:22AM Process 65241 ABENDED at Step GL_JPROC.DD020.LOGLOCK (SQL) -- RC = 805;
30 1:54:22AM 65241 GL_JPROC DD020 LOGLOCK SQL 805;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms