State Quarterly Wage Listing fails with Error Program-"Generate Mag XML" Failing In Production As Well As In Out Test Instance

(Doc ID 2353420.1)

Last updated on MAY 10, 2018

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 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 GRE to the California State Periodic wage listing
2. Submit the single request of the State Periodic wage listing
3. Observe the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot submit the State periodic wage listing (SPWL) for 4th Quarter with a due date of January 31st 2018

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