While Applying HRMS 9.1 Bundle #15 (Multilanguage) On MS SQL Server, Incorrect syntax Error Occurs for upd17656543.dms (Doc ID 2216147.1)

Last updated on DECEMBER 22, 2016

Applies to:

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

Symptoms

While Applying HRMS 9.1 Bundle #15 ML On MS SQL Server, Incorrect syntax Error Occurs
Script name: - upd17656543.dms

ERROR
-----------------------
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not
UPDATE PS_HRS_APP_CL_ITEM A SET A.CHECKLIST_CD=(SELECT B.CHECKLIST_CD FROM PS_HRS_APP_CHKLST B WHERE A.HRS_PERSON_ID=B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ=B.HRS_PROFILE_SEQ AND A.CHECKLIST_DT=B.CHECKLIST_DT) WHERE A.CHECKLIST_CD=' '
Error: SQL execute error for UPDATE PS_HRS_APP_CL_ITEM A SET A.CHECKLIST_CD=(SELECT B.CHECKLIST_CD FROM PS_HRS_APP_CHKLST B WHERE A.HRS_PERSON_ID=B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ=B.HRS_PROFILE_SEQ AND A.CHECKLIST_DT=B.CHECKLIST_DT) WHERE A.CHECKLIST_CD=' '
Ended: Thu Dec 01 14:00:00 2016
Unsuccessful completion


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Microsoft SQL Server, try to apply the multi language bundle HRMS 9.1.15
2. The script upd17656543.dms encounters an error

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