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.

Symptoms

When attempting to terminate a person
the following error occurs.

ERROR
-----------------------
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'

ADDITIONAL INFORMATION

-----------------------
no UK payroll being used


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