PERWSTEM Terminating EMployee Results in Error "ORA-04088: error during execution of trigger 'APPS.SSP_PER_T1'"

(Doc ID 1980212.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.


When attempting to terminate a person
the following error occurs.

Calling hr_person_api.update_gb_person API ORA-04091: table HR.PER_ALL_PEOPLE_F is mutating, trigger/function may not see it
ORA-06512: at "APPS.SSP_SSP_PKG", line 1284
ORA-06512: at "APPS.SSP_SSP_PKG", line 1297
ORA-06512: at "APPS.SSP_SSP_PKG", line 1402
ORA-06512: at "APPS.SSP_SSP_PKG", line 4278
ORA-06512: at "APPS.SSP_PER_T1", line 9
ORA-04088: error during execution of trigger 'APPS.SSP_PER_T1'


no UK payroll being used


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