Payroll Archive Process Errors: ORA-20001: 'Value exceeded allowable range' (Doc ID 2170596.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

After changing employees from one payroll to another in the middle of a pay period the Payroll Archive process errors.

ERROR
----------------------- 1st Error Message
Error ORA-20001: Error in pay_us_action_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

-----------------------2nd Error Message:
Error in pay_us_action_arch.process_actions-ORA-20001: Value exceeded allowable range

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.
 (3=TO_DATE)
Error at step 21 in pay_us_action_arch.action_archive_data-ORA-20001: Error in pay_us_action_arch.process_actions



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Employee changes payroll mid-period
2. Run Payroll processes
3. Run Payroll Archive process and receive error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.