Update Address Errors With FRM-40735: ON-UPDATE Trigger Raised Unhandled Exception ORA-44002 on Address Form (Doc ID 3027694.1)

Last updated on JUNE 07, 2024

Applies to:

Symptoms

When attempting to do any change to an address already created, the following error occurs on Address form after saving the data:

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


1. Using Responsibility: HRMS Manager.

2. Navigate to People > Enter and Maintain form.

3. Click on Address button.

4. Make a change to the person’s already existing address > Save.

5. After saving the changes, the error occurs.

Changes

Applying Patch 33527653 - R12.HR_PF.C.DELTA.16, in the run edition. Cutover phase is not completed.

Cause

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