Retro-Notifications Report (Enhanced) - PDF Errors: APP-PAY-06881: Error ORA-20001: HR_34988_TERMINATE_THREAD (Doc ID 2786106.1)

Last updated on MARCH 05, 2023

Applies to:

Symptoms

The Retro-Notifications Report (Enhanced) - PDF concurrent request or one of its Payroll Worker requests completes with error.  The error in seen in the log file.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: HR_34988_TERMINATE_THREAD
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 209
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 658
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 1100
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5214
ORA-06512: at line 2

SQL_NO 435
TABLE_NAME hr_nonrun_asact.asact
APP-PAY-06881: Error ORA-20001: HR_34988_TERMINATE_THREAD
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 209
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 658
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 1100
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5214
ORA-06512: at line 2
has occurred in table hr_nonrun_asact.asact at location 435

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

From HRMS Manager responsibility (or equivalent)
1. Navigate: Processes and Reports > Submit Processes and Reports > Singe Request
2. Submit the Retro Notifications Report (Enhanced) PDF
3. Review logs and see errors

Changes

Cause

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