Last updated on FEBRUARY 21, 2017
Applies to:Oracle Human Resources - Version 12.2.3 and later
Information in this document applies to any platform.
On : 12.2.3 version of the application, In the Contact Form.
When attempting to correct / update the existing contact information of Date of Birth the following error occurs.
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01407
The issue can be reproduced at will with the following steps:
1. Login using the "HRMS Manager" responsibility.
2. Navigate to People -> Enter and Maintain.
3. Query an employee, whose Contact details are to be modified.
4. update the data of birth
5. Getting above mentioned error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms