My Oracle Support Banner

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


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.  


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

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