EGL: Deadlock Occurred on Temporary Tables During Budget Checking

(Doc ID 620681.1)

Last updated on AUGUST 16, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 SP1 to 9 [Release 8.4 to 9]
Information in this document applies to any platform.
Enterprise, Financials, General Ledger, Commitment Control

Symptoms

The budget checking process is abending with the following error message:

[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 227) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
Dynamic Stmt : FSPKGCBL_D_HD000_1

This means that there is deadlocking on shared temp tables, e.g. KK_SRC_TMP and KK_TDET_TMP (_TMP).  Deadlocks in this situation may mean the application is running out of non-shared temp tables (_TMPxxx) because these tables would not be used if there were non-shared temp tables (KK_SRC_TMPxxx and KK_TDET_TMPxxx in this case) available.  

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