State Periodic Wage Listing (Enhanced) SPWL FAILING ORA-20001: ERROR AT STEP 2 IN PAY_MAG_XML.GENERATE_EMP_REC_XML -

(Doc ID 2392356.1)

Last updated on APRIL 27, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, US State Periodic Wage Listing (Enhanced)

When attempting to submit the State Periodic Wage Listing (Enhanced) for the State of Mississippi the following error occurs.

ERROR
-----------------------
SPWL FAILING ORA-20001: ERROR AT STEP 2 IN PAY_MAG_XML.GENERATE_EMP_REC_XML -

---------------------------------------------------
State of Mississippi Quarterly Unemployment process fails

The parent process Wage Listing (Enhanced) completes normal and kicks off a child process of

State Periodic Wage Listing (Internal) which also completes normal

However, it then kicks off the Generate SPWL XML (Generate Mag XML) process which then kicks off 4 payroll worker process slave process (which is normal for all states)
BUT it all ends up in ALL RED ERROR status and the records in error state.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the Single Request > State Periodic Wage Listing (SPWL) for the State of Mississippi
2. The parent process completes normal and kicks off a child process
3. Observe error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot submit the Mississippi State Periodic wage listing (SPWL) with a legislative due date one month after the end of the quarter

Changes

 Work Locations were consolidated and marked inactive

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