EAR9.1: UPD875578_01.DMS Fails (Failed SQL stmt:UPDATE PS_CUST_CONVER_DTL A SET CONVR_QUAL_BU) While Applying FMS Financials 9.1 Bundle #18 on SQL Server Platform (Doc ID 1450140.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms


On : 9.1 version, Accounts and Balances

When attempting to apply Bundle no. 18 the following error occurs.

ERROR
-----------------------
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 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 ','.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (S
Failed SQL stmt:UPDATE PS_CUST_CONVER_DTL A SET CONVR_QUAL_BU = (SELECT BUSINESS_UNIT FROM PS_CUST_CONVER_DTL B WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.CONV (200,0)
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'A'.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply FSCM 9.1 Bundle #18
2. Process fails at step UPD875578_01.DMS

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the bundle application

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