HRMS 9.0 Bundle #20 Causes Error in HR880588_01_DMS with SQL Server Database (Doc ID 1534063.1)

Last updated on OCTOBER 09, 2015

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9 version, HRMS Upgrade & Maintenance

When attempting to execute HR880588_01.dms from HRMS 9.0 bundle #20 (Update ID 874108), it fails and the following error occurs.

ERROR
-----------------------
Database: PSHDMO9Y (ENG)

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'D'.
[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt:UPDATE PS_DISABILITY D SET DISABL_STARTDT_ITA = (SELECT MIN(EFFDT) FROM PS_JOB J WHERE J.EMPLID = D.EMPLID) WHERE DISABILITY_ITA <> ' ' AND DISABL_STARTDT_I (200,0)
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'D'.

[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180

UPDATE PS_DISABILITY D SET DISABL_STARTDT_ITA = (SELECT MIN(EFFDT) FROM PS_JOB J WHERE J.EMPLID = D.EMPLID) WHERE DISABILITY_ITA <> ' ' AND DISABL_STARTDT_ITA IS NULL

Error: SQL execute error for UPDATE PS_DISABILITY D SET DISABL_STARTDT_ITA = (SELECT MIN(EFFDT) FROM PS_JOB J WHERE J.EMPLID = D.EMPLID) WHERE DISABILITY_ITA <> ' ' AND DISABL_STARTDT_ITA IS NULL

Ended: Wed Oct 10 12:01:56 2012

Unsuccessful completion

STEPS TO REPLICATE
-----------------------
The issue can be reproduced at will with the following steps:
1. Download and apply HRMS 9.0 bundle #20
2. While applying the bundle, execute HR880588_01.dms and above error message is seen.

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