When Attempting to Attach a Fast Formula to the Plans form, a Form Error Occurs

(Doc ID 2414556.1)

Last updated on JUNE 22, 2018

Applies to:

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

Symptoms

When attempting to create plan options and define an eligibility rule, the following error occurs:

ERROR
-----------------------
ORA-01403: no data found

------------------------------------------------------------
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01407.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to responsibility US Super HRMS Manager.
2. Navigate to Total Compensation > Programs and Plans > Plans form and query the plan in question.
3. Click the Options button and select the option in question.
4. Click the Option Eligibility button > > Eligibility button > Rule tab.
5. Attempt to attach a rule.
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