My Oracle Support Banner

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

Last updated on APRIL 04, 2025

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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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