State Periodic Wage Listing (Enhanced) will not Rollback and View > Payroll Proces Displays "Error MAG XML", Worker Log Error ORA-20001: Error at Step 3 in PAY_MAG_XML.POPULATE_ASG_ARCHIVED_VALUES (Doc ID 3015972.1)

Last updated on APRIL 10, 2024

Applies to:

Symptoms

When attempting to submit the State Periodic Wage Listing (Enhanced) for the State of Ohio the following error(s) occur.

1. From the Main Menu >  Navigate to View > Payroll Process Results > query in Action Type of Magnetic Report > Click the Find Button >

Observe the single message error  MAG XML "Error"

2) From View Requests > Locate the Worker log file from the State Periodic Wage Listing (SPWL) displays the error message:

Error message on the MAG XML was Error ORA-20001: Error at step 3 in PAY_MAG_XML.POPULATE_ASG_ARCHIVED_VALUES
ORA-06512: at "APPS.HR_UTILITY", line 970
ORA-06512: at "APPS.PAY_MAG_XML", line 2029
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "

The issue can be reproduced with the following steps:
1. Using US SUPER HRMS Manager or Equivalent. 
2. Submit the Concurrent Program > Single Request > State Periodic Wage Listing (Enhanced). 
3. Observe from the Main Menu > Navigate to View > Payroll Process Results > query in Action Type of Magnetic Report > Click the Find Button >Observe the error > MAG XML "Error".

Changes

 No 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.