My Oracle Support Banner

ETL9.2: Moving PS_EOAW_STEPINST and PS_EOAW_USERINST to Client Own Tablespaces with Row Level Locking due Deadlocks Occur when Approving Time. (Doc ID 2772190.1)

Last updated on MARCH 01, 2024

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Goal

Users can see the deadlock on both while approving on summary page and on the time sheet details page.

It is not just happening when a manager goes to approve time.

It is happening with an employees submit their time for approval.

It is also happening on Manage Self Service > Time Management > Approve Time and Exceptions > Reported time.

Customer is going to move PS_EOAW_STEPINST and PS_EOAW_USERINST to their own tablespaces with row level locking and was concerned about negative impact of the change on other functions, upgrades and maintenance.

Would the deadlocks continued after moving the tables to their own tablespace?


 

Solution

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
Goal
Solution
References


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