Adding a new Government Reporting Entity (GRE) and the State Periodic Wage Listing (SPWL) Ends with SQLERRMC ORA-20001: Error at step 3 in PAY_MAG_XML.GET_MF_A01_RECORD_XMLNot Producing .mf File (Doc ID 2827319.1)

Last updated on DECEMBER 02, 2024

Applies to:

Symptoms

On : 12.2 HRMS State Periodic Wage Listing (Enhanced) (SPWL).

The new GRE is not being picked up in the SPWL.

The .mf file for the new GRE is not being created.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Using US HRMS Manager > Navigate to Work Structure > Organization > Created New GRE.
2. Navigate to Process and Reports >Submit the Single Request > State Periodic Wage Listing (Enhanced).
3. Observe the error:

                 HR_6881_HRPROC_ORA_ERR
                 SQLERRMC ORA-20001: Error at step 3 in PAY_MAG_XML.GET_MF_A01_RECORD_XML
                 ORA-06512: at "APPS.HR_UTILITY", line 949
                 ORA-06512: at "APPS.PAY_MAG_XML", line 2734
                 ORA-06512: at line 1
                 ORA-06512: at "SYS.DBMS_SQL", line 1707
                 ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
                 ORA-06512: at line 1

Changes

 EBS Payroll Customer defined a new Government Reporting Entity (GRE).  The work location attached to the GRE was inactive.

Cause

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