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 MAY 26, 2023

Applies to:

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.