MSS Termination Transaction Not Saving When Encountering A CI Error Deadlock issue
Last updated on MAY 23, 2018
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When attempting to perform MSS termination,the following error contain in the mail.
The following transaction has failed to update the database.
Employee ID: %2
Employee Name: %3
Employee Record: %5
Effective Date: %6
Effective Sequence: %7
Action Reason: %9
CI error (i.e. No buffer rows, or contention/deadlock on the PSIBQUEUEINST or PSAPMSGPUBSYNC ),
The issue can be reproduced at will with the following steps:
When MSS Termination Request is submitted CI error occurs.The PS_HR_TERM_DAT and PS_HR_TERM_STA have no record for that submitted termination transaction and at the same time an email with %number bind variables is sent.
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