ORA-01422 Error Occurs When Attempting to Query Element in Earnings Form
(Doc ID 2585319.1)
Last updated on SEPTEMBER 05, 2019
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
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.
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
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
- 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