ORA-01422 Error Occurs When Attempting to Query Element in Earnings Form
(Doc ID 2585319.1)
Last updated on DECEMBER 11, 2023
Applies to:
Oracle HRMS (US) - Version 12.2 and laterInformation in this document applies to any platform.
Oracle HRMS (US) - Version 12.1 and later
This note provides a brief overview of
Symptoms
Problem Statement:
When attempting to query the element on the Earnings form, the following error occurs. This happens when there are datetrack records in the Formula Result Rules.
ORA-01422: exact fetch returns more than requested number of rows.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Login as US HRMS Manager responsibility
- Create a datetrack update in the formula processing rule.
(N) Total Compensation > Basic > Fast Formula > Formula Results
e.g.
Element: XXElement
Processing Rules (Formula): XXFormula1
Effective Date From: 01/JAN/2000
Effective Date To: 31/DEC/2010
Processing Rules (Formula): XXFormula2
Effective Date From: 01/JAN/2011
Effective Date To: null - Go to the Earnings form
(N) Total Compensation > Basic > Earnings - Query the element
e.g. XXElement - Error occurs
Cause
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
Symptoms |
Cause |
Solution |
References |