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.
When attempting to run three GPSG_IR8A_CR processes (Create IR8A/IR8S Forms) at the same time, 2 of the processes hit deadlock error :
09.27.06 Process 284894 ABENDED at Step GPSG_IR8A_CR.UPDATES.Step35 (Action SQL) -- RC = 60
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms