My Oracle Support Banner

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 JANUARY 03, 2020

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

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.