GPSGP: Deadlock Issue Running GPSG_IR8A_CR (Doc ID 2037860.1)

Last updated on AUGUST 06, 2015

Applies to:

PeopleSoft Enterprise HCM Global Payroll Singapore - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run three GPSG_IR8A_CR processes (Create IR8A/IR8S Forms) at the same time, 2 of the processes hit deadlock error :

ERROR
-------------
09.27.06 Process 284894 ABENDED at Step GPSG_IR8A_CR.UPDATES.Step35 (Action SQL) -- RC = 60
ROLLBACK

SQL Error: ORA-00060: deadlock detected while waiting for resource


The 3 processes details as below :
- 1st pay entity approximately 4500 employees
- 2nd pay entity approximately 1000 employees
- 3rd pay entity approximately 600 employees


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Create IR8A/IR8S Forms for 3 pay entities (Employer's Tax Ref. No.), with volume data, and different run control ID.

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