California SPWL Is Failing Table Pay_archive.process_employee At Location 1108 With The Error Text (Doc ID 2268811.1)

Last updated on MAY 22, 2017

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.
State Periodic Wage Listing (Enhanced) SPWL

Symptoms

On : 12.2.4 version, State Periodic Wage Listing (Enhanced)

When attempting to submit the California State Periodic Wage Listing (Enhanced) after the application of Quarter 1 and hrglobal the following error occurs for all assignment_ids in the Government Reporting Entity (GRE).

ERROR
-----------------------
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. Submitted the Quarter 1 State Periodic Wage Listing (Enhanced)

2. State Periodic Wage Listing (SPWL) Enhanced errors for the State of California for all assignments_ids in the State of California for this GRE

 

BUSINESS IMPACT

-----------------------
The issue has the following business impact:


Due to this issue, users cannot Submit the State Quarterly Wage Listing (Enhanced) for the State of California without error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms