My Oracle Support Banner

E-AWE: Database Deadlocks Occurring when Approving Workflow Transactions (Doc ID 2827530.1)

Last updated on JUNE 03, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms

Customer is seeing database deadlocks on the AWE tables when approving/denying transactions.  The application server log shows the following error:


Sample environment:
------------------------
PeopleTools: 8.58.09
HCM 9.2 PUM 37
MS SQL Server 2017
Production environment

Steps to replicate:
-----------------------

1. Log into PIA via a browser, and navigate to any AWE process e.g. in this particular scenario it is Time Reporting (Home > Manager Self Service > Time Management > Approve Time and Exceptions > Reported Time > Approve Reported Time)
2. Review the submitted transaction as needed
3. Click either the Approve or Deny button 

 

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


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