California State Quarterly Wage Listing (SQWL) Ends In Error Error Ora-6503 Pl/sql Function Returned Without Value (Doc ID 1925170.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

On :  12.1 HRMS RUP6 version, US Payroll Tax Issues in DEV and PRODUCTION instance

When attempting to submit the State Quarterly Wage listing (SQWL) Enhanced Quarter 2 the following error occurs.

ERROR
-----------------------
Error ora-6503 pl/sql
function returned without value
Ora-6512 at
APPS.PAY_BALANCE_PKG, line 1101
ORA-6512 at APPS.PAY_ARCHIVE,
line 1233
ORA-6512 at line 3
Has occurred in table
pay_archive.process_employee at location 1108


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit process and reports > single request > state quarterly wage listing
2. parameters: 2014, Quarter 2, GRE all, state format, create audit report and fold NO
3. When process finishes there are no files that are created due to the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully create the SQWL files for the State of California for Quarter 2 which has a legislative deadline of July 31st

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