ORA-20001: Value exceeded allowable range (line 23 of PQP_GB_TP_CRITERIA_ANNUAL_TYPE1_RULE)
(Doc ID 1060059.1)
Last updated on DECEMBER 09, 2022
Applies to:
Oracle HRMS (UK) - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to setup the Teachers Pension Extract (Type1) the following error occurs:
ORA-20001: Value exceeded allowable range (line 23 of PQP_GB_TP_CRITERIA_ANNUAL_TYPE1_RULE)
Cause: Caused by Oracle error 6502 occurring during the execution of the formula which is raised when an arithmetic conversion error, or string truncation error occurs. This can also be caused by invalid dates, for example 39-DEC-1991, 24-MAR-5000
Action: Check your formula for possible invalid dates, numbers or strings greater than 255 characters in length.
Cause: Caused by Oracle error 6502 occurring during the execution of the formula which is raised when an arithmetic conversion error, or string truncation error occurs. This can also be caused by invalid dates, for example 39-DEC-1991, 24-MAR-5000
Action: Check your formula for possible invalid dates, numbers or strings greater than 255 characters in length.
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 |