Payment Summary Archive For Employee with Termination Type: Death, Errors: ORA-01722: invalid number (Doc ID 2289493.1)

Last updated on JULY 25, 2017

Applies to:

Oracle HRMS (Australia) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Post AU.25

When running the Payment Summary Archive process for a terminated employee with Termination Type: Death, the following error occurs.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01722: invalid number
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-01722: invalid number
ORA-06512: at "APPS.PAY_ARCHIVE:, line 1207
ORA-06512: at line 3
 has occurred in table pay_archive.process_employee at location 1108

Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_employee at location 1108 with error text ORA-01722: invalid number
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

Action: Please contact your support representative.



Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Terminate employee with Termination Type: Death
2. Run quickpay/ payroll
3. Run Payment Summary Archive
4. See the error in the log file


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