T4 PDF Failing on APPS.PAY_CA_T4_XML with Error 'ORA-06512: at "APPS.PAY_CA_T4_XML", line 256' (Doc ID 782059.1)

Last updated on JUNE 12, 2017

Applies to:

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

Symptoms

-- Problem Statement:
When submitting the T4 PDF concurrent request, the following error occurs:

ERROR
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001:
ORA-06512: at "APPS.PAY_CA_T4_XML", line 256
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1

SQL_NO 2549
TABLE_NAME pay_mag_tape.run_xml_proc
APP-PAY-06881: Error ORA-20001:
ORA-06512: at "APPS.PAY_CA_T4_XML", line 256
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1
has occurred in table pay_mag_tape.run_xml_proc at location 2549

Cause: an oracle error has occurred. The failure was reported on table
pay_mag_tape.run_xml_proc at location 2549 with the error text ORA-20001:
ORA-06512: at "APPS.PAY_CA_T4_XML", line 256
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1
Action: Please contact your support representative.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Submit T4 PDF.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot generate T4s.

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