PERWSHRG Updating an Employee Assignment Errors with FRM-40735: ON-UPDATE Trigger Raised Unhandled Exception ORA-06502 (Doc ID 1293514.1)

Last updated on AUGUST 10, 2017

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

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms