'FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06511' When Updating Enrollments After RUP7 Patch 18004477
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.
On 12.1 HRMS RUP7 version in Oracle Advanced Benefits,
When attempting to change and save enrollments, the following error occurs:
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms