My Oracle Support Banner

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 SEPTEMBER 09, 2020

Applies to:

Oracle HRMS (US) - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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