ELA: DCRE25539514.MAIN.Step08 Fails Applying Image #24 Change Package (Doc ID 2286832.1)

Last updated on JULY 26, 2017

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

DCRE25539514.MAIN.Step08 fails applying Image #24 Change Package

While trying to apply a Change Package for Image #24 to my test environment. Under "Running Data Conversion" in Upgrade Assistant, the "Run Data Conversion AE - DCRE23339514" step failed with the attached SQL error:

The step that failed is DCRE25539514.MAIN.Step08. The SQL does not seem to be valid for MS SQL Server:

UPDATE ps_re_ls_ppty t1
  SET t1.ASSET_CLASSIFY = (
 SELECT t2.LS_CLASSIFICATION
  FROM ps_re_ls t2
 WHERE t1.LS_KEY = t2.LS_KEY )
 WHERE EXISTS (
 SELECT 1
  FROM ps_re_ls t2
 WHERE t1.LS_KEY = t2.LS_KEY
  AND t2.LEASE_STATUS <> '1')

ERROR
-----------------------

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could no
Failed SQL stmt: UPDATE ps_re_ls_ppty t1 SET t1.ASSET_CLASSIFY = ( SELECT t2.LS_CLASSIFICATION FROM ps_re_ls t2 WHERE t1.LS_KE (200,0)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applying Change Package for Image #24
2. "Running Data Conversion" in Change Assistant

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

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