EGL9.2: GL_JP And GLPOCONS Deadlock When Both The Processes Are Run In Parallel

(Doc ID 2355270.1)

Last updated on FEBRUARY 02, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------
Deadlock occurred when the processes GL_JP and GLPOCONS processes are run in parallel.


Steps to Replicate:
---------------------
Run the GL_JP journal post process and GLPOCONS consolidation process in parallel.

Error:
------
1723 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205.


Failed SQL stmt: UPDATE PS_JRNL_HEADER SET PROCESS_INSTANCE=152346, JOURNAL_LOCKED = 'Y' WHERE JOURNAL_LOCKED <> 'Y' AND JRNL_HDR_STATUS <> 'D' AND ( LEDGER_GROUP = 'ACTUALS' ) AND SUSP_RECON_STATUS <> '2' AND SYSTEM_SOURCE <> 'SCE' AND SYSTEM_SOURCE <> 'SCV' AND (KK_AMOUNT_TYPE = '1' OR KK_AMOUNT_TYPE = '7') AND ( ('N' = 'N' AND JRNL_HDR_STATUS='P' AND JRNL_PROCESS_REQST='U' ) OR ('N' = 'Y' AND UNPOST_SEQ <> 1 AND (JRNL_HDR_STATUS='P' OR (JRNL_HDR_STATUS <> 'P' AND JRNL_HDR_STATUS <> 'U' ) ) )) AND LEDGER_GROUP= 'ACTUALS' AND BUSINESS_UNIT= 'ELM05'

Process 152346 ABENDED at Step GL_JP_UNPOST.MAIN.LockJrnl (SQL) -- RC = 8601

Actual Behavior:
------------------
GLPOCONS process went to success but GL_JP process failed with error.

Expected Behavior:
-------------------
GLPOCONS and GL_JP must go to success without any issues

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