My Oracle Support Banner

When Attempting to Attach a Fast Formula to the Plans form, a Form Error Occurs (Doc ID 2414556.1)

Last updated on FEBRUARY 17, 2019

Applies to:

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


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

ORA-01403: no data found

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

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.


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

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