Error FRM-40735 and ORA-04098 or ORA-44002 when Saving New Employee or Create or Update a Location
(Doc ID 329780.1)
Last updated on NOVEMBER 29, 2024
Applies to:
Oracle Human Resources - Version 11.5.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to enter a new employee and save the record, on Enter and Maintain form, the following error occurs:
--------------------------------------------------------------
ORA-04098: trigger 'PER.DR$PER_ADDRESSES_N4TC' is invalid and failed re-validation
ORA-06512: at "APPS.PER_HRTCA_MERGE", line 1145
ORA-06512: at "APPS.PER_HRTCA_MERGE", line 1843
ORA-06512: at "APPS.HR_PER_TYPE_USAGE_INTERNAL", line 129
ORA-06512: at "APPS.HR_PER_TYPE_USAGE_INTERNAL", line 844
ORA-06512: at "APPS.PER_PEOPLE11_PKG", line 698
The issue can be reproduced at will with the following steps:
1. Using HRMS Manager responsibility.
2. Navigate to > People > Enter and Maintain.
3. enter new employee details and save.
4. Get error.
OR
When trying to create or update a location, the following error occurs.
The issue can be reproduced at will with the following steps:
1. Using Setup User responsibility.
2. Navigate to Navigate to Setup > Organization > Location.
3. Try to create or update a location > Save.
4. Get error.
OR
When trying to create a location or to add an employee, the following error occurs.
The issue can be reproduced at will with the following steps:
1. Using HRMS Manager responsibility.
2. Navigate to Work Structure > Locations.
3. Create a new Location > Save.
4. Get error.
OR
The issue can be reproduced at will with the following steps:
1. Using HR Foundation responsibility.
2. Navigate to People > Enter and Maintain.
3. Enter the details > Save.
4. Get error.
Changes
The database was upgraded.
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 |