My Oracle Support Banner

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


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