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 (Doc ID 889881.1)

Last updated on MAY 13, 2016

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.

Goal

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).

Journal Generator error
File: e:\pt84916b-retail\peopl etools\src\psappeng\aedebug.hSQL error. Stmt #: 1603 ;Error Position: 0 ;Return: 805 - ORA -00001: unique constraint (SYS ADM.PS_GL_JCOBOL_TMP) violated ;Failed SQL stmt:INSERT INTO PS _GL_JCOBOL_TMP (PROCESS_INSTANCE);
Process 525075 ABENDED at Step GL_JPROC.DD810.INST_TMP (SQL) -- RC = 805
Journal Edit error
1:54:21AM File: e:\pt84923b-retail\peopl etools\src\psappeng\aedebug.hS QL error. Stmt #: 1603 Error Position: 0 Return: 805 - [Microsoft][SQL Native Client][SQL Server]Cannot insert duplica te key row in object 'dbo.PS_JRNL_EDIT_LOG' with unique index 'PS_JRNL_EDIT_LOG'.;
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;

Solution

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