My Oracle Support Banner

FRM-40735 ORA-01403 ORA-06502 Errors while Updating Assignments (Doc ID 335062.1)

Last updated on JANUARY 30, 2024

Applies to:

Oracle Human Resources - Version to 12 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
FORM:PERWSHRG.FMB - Combined Person & Assignment Form


Relevancy Checked - 08-MAR-2011

While attempting to update any assignment information for any employee, the following errors are observed:

ORA-01403: no data found
FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-06502.


> People > Enter and Maintain
> Query Person > [Assignment]
> Statutory Information Tab
> Change a Value > Save

This seems to be only happening for responsibilities attached to US legislation.
Responsibilities attached to Canadian legislation appear to be working fine.


Upgrade from 11.5.8 to 11.5.10;  this functionality was working previously on 11.5.8 HR FP C



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

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