ORA-20001: FFX22J_FORMULA_NOT_FOUND Error received when viewing the Previous Balances from Entitlement Tab on Absence Page
(Doc ID 2625830.1)
Last updated on JUNE 07, 2021
Applies to:Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Assignment,Term,Pay,ChgMgr,LOA
When attempting to view the previous balances from entitlement tab on Absence page,
the following error occurs.
You have encountered an unexpected error. Please contact the System Administrator for assistance
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: FFX22J_FORMULA_NOT_FOUND: N, 1
ORA-06512: at "APPS.PER_FORMULA_FUNCTIONS", line 608
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 70
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 129
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 923
ORA-06512: at "APPS.PER_DISPLAY_ACCRUAL_BALANCE", line 359
ORA-06512: at line 2
The issue can be reproduced at will with the following steps:
1. Login application with Employee Self Service Responsibility
2. Navigate to Absence page/function
3. Click on entitlement tab on Absence page to check the balances.
4. Change the Effective date to past date , click go.
5. Getting above mentioned error
Example: Current Date say 03-Jan-2020
When try to change the effective date as 31-DEC-2019 and try to view the balances , get above mentioned error.
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