PERWSHRG:Changing Gender Information Gives Error ORA-04091: Table HR.PER_ALL_PEOPLE_F
(Doc ID 568103.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Human Resources - Version 184.108.40.206 to 220.127.116.11 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 26-Apr-2010
-- 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