ORA-20001: Value exceeded allowable range (line 23 of PQP_GB_TP_CRITERIA_ANNUAL_TYPE1_RULE) (Doc ID 1060059.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle HRMS (UK) - Version 11.5.10.2 and later
Information 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.

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms