My Oracle Support Banner

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 later
Information in this document applies to any platform.
Oracle HRMS (US) - Version 12.1 and later
This note provides a brief overview of and .


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:

  1.  Login as US HRMS Manager responsibility

  2.  Create a datetrack update in the formula processing rule.
     (N) Total Compensation > Basic > Fast Formula > Formula Results
     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

  3.  Go to the Earnings form
    (N) Total Compensation > Basic > Earnings

  4.  Query the element
     e.g. XXElement
  5.  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.