My Oracle Support Banner

MSS Termination Transaction Not Saving When Encountering A CI Error Deadlock issue (Doc ID 2402203.1)

Last updated on DECEMBER 01, 2020

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
Transaction: %4
Employee Record: %5
Effective Date: %6
Effective Sequence: %7
Action: %8
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.


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

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