Kentucky State Period Wage Listing (Enhanced) (SPWL) For 3rd QTR Completes In Error (Doc ID 2069073.1)

Last updated on MAY 04, 2021

Applies to:

Symptoms

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

When attempting to run the State Periodic Wage Listing report (SPWL) the following error occurs.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3


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

1. using the US SUPER HRMS Manager responsibility

2  Navigating to Submit Process and Reports > Single Request > State Periodic Wage Listing (Enhanced)

3. View Request > Observe no employees listed in the .a02 file

4. No assignment_id listed in the log file with the error message

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.