'FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06511' When Updating Enrollments After RUP7 Patch 18004477 (Doc ID 1936302.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

On 12.1 HRMS RUP7 version in Oracle Advanced Benefits,

When attempting to change and save enrollments, the following error occurs:

ERROR
-----------------------
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06511

ORA-06511: PL/SQL: cursor already open Cause: An unexpected Oracle error has occurred. Action: Please refer to your system administrator.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Open event and save the default currently enrolled plan.
2. Change the currently enrolled plan to a different plan and save.
3. Now change the plan back to the originally enrolled plan and try to Save.
Error occurs.

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