My Oracle Support Banner

"FRM-40735: ON ERROR Trigger Raised Unhandled Exception ORA-06502" While Updating Location (Doc ID 3042841.1)

Last updated on AUGUST 21, 2024

Applies to:

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

Symptoms

When trying to modify Location, following error appears

ERROR

FRM-40735: ON ERROR trigger raised unhandled exception ORA-06502


The issue can be reproduced at will with the following steps:

1. Login to "HRMS Manager" responsibility.

2. Navigate to Work Structures -> Location.

3. Query an existing location.

4. Update any field like Address segments or description and try to save it.

5. Encounter the above 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.