State Periodic Wage Listing (SPWL) fails with Error Program-"Generate Mag XML" Failing In Production As Well As In Out Test Instance (Doc ID 2353420.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

On : 12.1 HRMS RUP10 version, State Periodic Wage listing

When attempting to submit the single request of the State Periodic Wage Listing (SPWL) the following error occurs.

ERROR
-----------------------
***** Processing Ass Id 13228 Status 1
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error at step 2 in PAY_MAG_XML.GENERATE_EMP_REC_XML
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.PAY_MAG_XML", line 2025
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
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: Error at step 2 in PAY_MAG_XML.GENERATE_EMP_REC_XML
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.PAY_MAG_XML", line 2025
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Customer added a new Government Reporting Entity (GRE) to the California State Periodic Wage Listing
2. Submit the single request of the State Periodic Wage Listing
3. Observe the error

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.