PERWSHRG Updating an Employee Assignment Errors with FRM-40735: ON-UPDATE Trigger Raised Unhandled Exception ORA-06502
(Doc ID 1293514.1)
Last updated on SEPTEMBER 08, 2022
Applies to:
Oracle Human Resources - Version 12.1.2 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
When attempting to update an employee assignment, the following error occurs.
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06502
ORA-06502: PL/SQL: numeric or value error
APP-PER-52156: You cannot update this assignment with these details. To correct the original problem please query this assignment and reapply your change.
STEPS
---------
The issue can be reproduced at will with the following steps:
- A single employee with multiple assignments (this could be an employee with multiple employee assignments, or an Employee.Applicant)
Assignment > Create new from 01-DEC-2010
Save
- At sysdate, both assignments are effective
- Attempt a DT update for a date earlier than sysdate on the Employee assignment (e.g. change hours), when the other assignment is not yet effective.
Date Track to 10-NOV-2010 > Assignment (1) Change any field -> Save -> Receive 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 |
References |