My Oracle Support Banner

Submitting the State Periodic Wage Listing (Enhanced) for Arizona (AZ) Immediately Errors ORA-06512: at "APPS.PAY_US_REPORTING_UTILS_PKG", line 2870 (Doc ID 2741158.1)

Last updated on APRIL 28, 2021

Applies to:

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

Symptoms

On : 12.1.3 version, State Periodic Wage Listings (SPWL)

When attempting to Submit the State of Arizona State Periodic Wage Listing the following error occurs immediately upon submission:

ERROR
-----------------------

Cause: FDPSTP failed due to ORA-20001:
ORA-06512: at "APPS.HR_UTILITY", line 949
ORA-06512: at "APPS.PAY_US_REPORTING_UTILS_PKG", line 2870
ORA-06512: at "APPS.PAY_US_SPWL_GRE", line 378
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applied the Legislative EBS Payroll Patches 
2. Navigate to Submit Process and Reports > Single Request > State Periodic Wage Listing (Enhanced) for the State of Arizona (AZ)
3. Unable to capture a LOG file as the SPWL immediately errors out

 

Changes

 Applied the 1st Quarter 2020 Statutory Patch Read me for Release 12.2 (Doc ID 2653963.1)

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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