GPJPN: GPJP_YEALOAD Aborted After Applied Global Payroll 9.1 Update 2016-B (Doc ID 2194802.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Symptoms

Issue
------------------
After applied GLOBAL PAYROLL 9.1 UPDATE 2016-B, when running GPJP_YEALOAD, process aborted due to the below SQL error;
This customer is using PeopleSoft HCM on the SQL Server database.

Error
------------------
File: e:\pt85115b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 8601 -
[Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value '-12-31' to data type int.(SQLSTATE 22005) 245
Failed SQL stmt:UPDATE PS_GPJP_YEA_TABLE SET GPJP_YEA_DEP_NRSD = ( SELECT COUNT(A.DEPENDENT_BENEF) FROM PS_GPJP_IT_DEP_TAX A WHERE A.EMPLID = PS_GPJP_YEA_TABLE.EMPLID
AND A.EFFDT=(SELECT MAX(EFFDT) FROM PS_GPJP_IT_DEP_TAX AA WHERE AA.EMPLID=A.EMPLID AND AA.DEPENDENT_BENEF=A.DEPENDENT_BENEF AND AA.EFFDT<=2016 + '-12-31')
AND A.GPJP_NO_RSDNT_RLTV = 'Y') WHERE DATE_YEAR_VAL = 2016

Process 149989 abended at Step GPJP_YEALOAD.03UPD9.Step08 (SQL). RC = 8601。 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Step:
------------------
1. Run GPJP_YEALOAD after applied GLOBAL PAYROLL 9.1 UPDATE 2016-B

Actual Behavior
------------------
GPJP_YEALOAD aborted after applied GLOBAL PAYROLL 9.1 UPDATE 2016-B

Expected Behavior
------------------
GPJP_YEALOAD runs correctly even if after applied GLOBAL PAYROLL 9.1 UPDATE 2016-B

Business Impacts
------------------
Due to this issue, users cannot process the year end adjustment.

Cause

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