Submitting Concurrent Program (CP) Single Request > State W-2 Magnetic Media For Missouri (MO), Error Occurs ORA-6512 at APPS.PAY_POPULATION_RANGE_PKG line 593 Error ORA – 20001 error in eoy_archive_gre_data_after step: 250sqlcode (Doc ID 3070532.1)

Last updated on FEBRUARY 03, 2025

Applies to:

Symptoms

When attempting to Submit the Single Request >State W-2 Magnetic Media for the parameters of 2024 and the State of Missouri the following error occurs:

ERROR
-----------------------
ORA-6512 at APPS.PAY_US_MMREF_REPORTING line 1319
ORA – 6512 at line
ORA-6512 at APPS.PAY_POPULATION_RANGE_PKG line 593
Error ORA – 20001 error in eoy_archive_gre_data_after step:
250sqlcode

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

1. Using the US SUPER HRMS Manager or Equivalent.

2. Submit the Single Request > Year End Pre-Process.

3. Disburse the Employee W-2 PDF's.

4. All other State W2 Magnetic Media finished without error.

5. Submit the Single Request > For the State of Missouri State W2 Magnetic Media.

6. Observe the error:

ORA-6512 at APPS.PAY_US_MMREF_REPORTING line 1319
ORA – 6512 at line
ORA-6512 at APPS.PAY_POPULATION_RANGE_PKG line 593
Error ORA – 20001 error in eoy_archive_gre_data_after step:
250sqlcode

7. Customer added the MO GRE details to Work Structures > Organization > GRE/Legal > Others > State Tax Rules.

8. The single request was submitted > Year End Pre-Process Re-Archive (ER info only) with parameters of 2024, State and MO.

9. Observe the additional error:

Cause: FDPSTP failed due to ORA-20001: Error in eoy_archive_gre_data after step : 250sqlcode : -20001
ORA-06512: at "APPS.PAY_US_ARCHIVE", line 3533
ORA-06512: at "APPS.PAY_US_ER_REARCH", line 243
ORA-06512: at line 1
.

Changes

 The Missouri State Account number was added to the GRE after the Year End Pre Process was submitted.

Cause

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