My Oracle Support Banner

Update Position Using Future Date Errors FRM-40735: ON-UPDATE Trigger Raised Unhandled Exception ORA-20002. (Doc ID 3028144.1)

Last updated on JUNE 24, 2024

Applies to:

Oracle Human Resources - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When trying to update Position using future date change and save , the following error occurs .

FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-20002.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 1. Responsibility:  XX HRMS Manager. 
 2. Navigate: Work Structures > Position > Description.
 3. Select the Datetrack button and datetrack to any future date.
 4. Update the Position and save then , it errors. 


 

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
References


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