My Oracle Support Banner

PERWSHRG:Changing Gender Information Gives Error ORA-04091: Table HR.PER_ALL_PEOPLE_F (Doc ID 568103.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Human Resources - Version to [Release 11.5.10]
Information in this document applies to any platform.


-- Problem Statement:
When attempting to change the gender information from male to female on the Person form,
the following error occurs:

ORA-04091: table HR.PER_ALL_PEOPLE_F is mutating, trigger/function may not see it
ORA-06512 at "APPS.SSP_SSP_PKG", line 1244
ORA-06512 at "APPS.SSP_SSP_PKG", line 1257
ORA-06512 at "APPS.SSP_SSP_PKG", line 1362
ORA-06512 at "APPS.SSP_SSP_PKG", line 4105
ORA-06512 at "APPS.SSP_PER_T1", line 9
ORA-04088: error during execution of trigger 'APPS.SSP_PER_T1'
ORA-06512 at "APPS.PER_PEOPLE12_PKG", line 1388

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1) Log in with UK HRMS Manager responsibility
2) Navigate to People > Enter and Maintain form
3) Change effective date to September 2004 (when applicant record was created)
4) Find the applicant record
5) Change gender value from male to female
6) Save & Error


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.