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 DECEMBER 04, 2019

Applies to:

Oracle Human Resources - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 26-Apr-2010


Symptoms

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

ERROR
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

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
Cause
Solution

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