NL - Templates - Saving Record Errors with ORA-01427: single-row subquery returns more than one row
Last updated on OCTOBER 12, 2017
Applies to:Oracle HRMS (Netherlands) - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.
On : 12.1 HRMS RUP7 version, Netherlands HR
When attempting to update and save information for NL employee using Templates form the following error occurs.
ORA-01427: single-row subquery returns more than one row
FRM-40735: HR_NL_EVENT trigger raised unhandled exception ORA-01427.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Responsibility: NL HRMS Manager
2. Function: Maintain employees
3. Effective Date Option : Select No
4. Search for employee record and click on details
5. Go to Assignment tab:
change the grade or any other information and click save:
It works fine from Core HR – NL HRMS Manager – People – Enter and Maintain form.
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