EGL9.1: FSPCCURR Abended At Step GL_JPROC.DD020.LOGLOCK (SQL) -- RC = 805 when Processing Multiple Groups with Same Step. (Doc ID 1385025.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked For Relevance on 20-May-2013***
***Checked For Relevance on 27-OCT-2014***

Symptoms

Journal post fails with: Cannot insert duplicate key row in object 'dbo.PS_JRNL_EDIT_LOG' with unique index 'PS_JRNL_EDIT_LOG.
This occurs when processing multiple groups linked to the same revaluation step.

ERROR
-----------------------
File: e:\pt85111b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_JRNL_EDIT_LOG' with unique index 'PS_JRNL_EDIT_LOG'.
Failed SQL stmt:INSERT INTO PS_JRNL_EDIT_LOG (PROCESS_INSTANCE , JRNL_EDT_PRCS_ORIG , OPRID , RUN_CNTL_ID , DTTM_STAMP_SEC) VALUES (10905 , 'A' , 'VP1' , 'TEST' , GETDATE())

Process 10905 ABENDED at Step GL_JPROC.DD020.LOGLOCK (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to General Ledger > Process Multi-Currency > Define and Process > Revaluation Step and open step REVALBAL. Make sure Create Journal Entries, Edit Journal(s) and Post Journal(s) is enabled on tab 'Output and Journal Options'.
2. Navigate to General Ledger > Process Multi-Currency > Define and Process > Define Process Group and link step REVALBAL to group REVALBAL and also to group REVBALMB.
3. Navigate to General Ledger > Process Multi-Currency > Define and Process > Request Process. Create a run control, define one row for business unit US001 group REVALBAL, one row for GBR01 group REVBALMB and run the MultiCurrency Process FSPCCURR.

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