GPJPN: Load Unemployment Cert JPN (GPJP_UCLOAD) Aborted After Applied GP9.1 2016-C (Doc ID 2194801.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Symptoms

Issue
------------------
This issue is a specific for SQL Server platform.
After applied GLOBAL PAYROLL 9.1 UPDATE 2016-C, Load Unemployment Cert JPN (GPJP_UCLOAD) aborted with the below error;

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]'ADD_MONTHS' is not a recognized built-in function name.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not
be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt:INSERT INTO PS_GPJP_UC3_TM_TBL (PROCESS_INSTANCE ,SEQNUM
,SEQ_NUM , EMPLID , EMPL_RCD , GPJP_UC_TERM_DATE ,
GPJP_START_DATE , GPJP_END_DATE , GPJP_WORKER_IND , DATE_FROM , DATE_TO)
SELECT A.PROCESS_INSTANCE ,B.SEQNUM ,0 , A.EMPLID ,
A.EMPL_RCD , A.GPJP_UC_TERM_DATE , DATEADD(DAY, +1, DATEADD(MONTH, -B.SEQNUM,
A.GPJP_END_DATE)) , DATEADD(MONTH, -(B.SEQNUM -1),
A.GPJP_END_DATE) , A.GPJP_WORKER_IND , A.GPJP_START_DATE , A.GPJP_END_DATE
FROM PS_GPJP_UC2_TAO4 A , PS_GPJP_SEQ B
WHERE A.GPJP_START_DATE <= ADD_MONTHS(A.GPJP_END_DATE, -(B.SEQNUM - 1)) AND
A.PROCESS_INSTANCE = 161291

Process 161291 abended at the step GPJP_UCLOAD.BB_L_UC3.Step011 (SQL). RC =
8601&#12290; (108,524)

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

Step:
------------------
1. Run Load Unemployment Cert JPN (GPJP_UCLOAD) after applied GLOBAL PAYROLL 9.1 UPDATE 2016-C

Actual Behavior
------------------
GPJP_UCLOAD aborted after applied GLOBAL PAYROLL 9.1 UPDATE 2016-C

Expected Behavior
------------------
GPJP_UCLOAD runs correctly even if after applied GLOBAL PAYROLL 9.1 UPDATE 2016-C

Business Impacts
------------------
Due to this issue, users cannot load the unemployment information.

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.