HR_PER502 App Engine Causes Blocking Locks When Deleting Emplid's.

(Doc ID 2318037.1)

Last updated on OCTOBER 16, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running the HR_PER502 App Engine process, it causes blocking locks when deleting emplid's.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to Set Up SACR > System Administration > Database Processing > ID Delete and run application engine process HR_PER502.

BUSINESS IMPACT
-------------------------------
The issue has the following business impact:

Due to this issue, CS and HR environments are unavailable to users for several hours due to excess blocking locks.

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