Applying 9.1 bundle 25: Fails on Execute AE programs step DC937646

(Doc ID 2321319.1)

Last updated on OCTOBER 25, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

HCM 9.1
PT 8.55.10
SQL Server 2012
all windows 2012 64bit RD

Applying 9.1 bundle 25

Fails on Execute AE programs step # DC937646.

Error log below.
It seems the SQL behind the AE is for Oracle DB.

PeopleTools 8.55.10 - Application Engine
Copyright (c) 1988-2017 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85510b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near
Failed SQL stmt: UPDATE PS_DEP_BENEF_ARG A SET A.INC_TAX_ENDDT_ARG = ( SELECT DATEADD(YEAR, 18, B.BIRTHDATE) FROM PS_DEP_BEN B WHERE B.EMPLID = A.EMPLID AND B.DEPENDENT_BENEF = A.DEPENDENT_BENEF) WHERE A.EFFDT IN ( SELECT D.EFFDT FROM PS_DEP_BEN_EFF D WHERE D.EMPLID = A.EMPLID AND D.DEPENDENT_BENEF = A.DEPENDENT_BENEF AND D.DISABLED = 'N' AND D.EFFDT >= '2017-01-01') AND A.INC_TAX_DEPEN_ARG = 'C'

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt85510b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near
Failed SQL stmt: UPDATE PS_DEP_BENEF_ARG A SET A.INC_TAX_ENDDT_ARG = ( SELECT DATEADD(YEAR, 18, B.BIRTHDATE) FROM PS_DEP_BEN B (200,0)
Process 4929 ABENDED at Step DC937646.MAIN.Upd2017 (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 4929 ABENDED at Step DC937646.MAIN.Upd2017 (SQL) -- RC = 8601 (108,524)

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

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