My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.