E-PUM UPDATE PS_RE_LSA_PPTY SET PS_RE_LSA_PPTY.EXISTING_ASSET = 'Y' WHERE PS_RE_LSA_PPTY.EXISTING_ASSET = 'N' AND ( (200,0) - applying FSCM Image 9.2.0.25

(Doc ID 2346734.1)

Last updated on JANUARY 11, 2018

Applies to:

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

Symptoms

Issue:
--------

Error in CA job while applying FSCM image 9.2.0.25. CA job is failing at one Data conversion step namely "Data Conversion AE-DCRE25539514"
 

Steps to replicate:
-------------------
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

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

Message Reason: Process 143207 ABENDED at Step DCRE25539514.MAIN.Step25 (SQL) -- RC = 8601 (108,524)

Failed SQL stmt: UPDATE PS_RE_LSA_PPTY SET PS_RE_LSA_PPTY.EXISTING_ASSET = 'Y' WHERE PS_RE_LSA_PPTY.EXISTING_ASSET = 'N' AND (PS_RE_LSA_PPTY.LS_KEY, PS_RE_LSA_PPTY.ASSET_SEQ_NBR, PS_RE_LSA_PPTY.PROPERTY_ID, PS_RE_LSA_PPTY.ASSET_ID) IN ( SELECT PS_RE_LS_PPTY.LS_KEY , PS_RE_LS_PPTY.ASSET_SEQ_NBR , PS_RE_LS_PPTY.PROPERTY_ID , PS_RE_LS_PPTY.ASSET_ID FROM PS_RE_LS_PPTY WHERE PS_RE_LSA_PPTY.LS_KEY = PS_RE_LS_PPTY.LS_KEY AND PS_RE_LSA_PPTY.ASSET_SEQ_NBR = PS_RE_LS_PPTY.ASSET_SEQ_NBR AND PS_RE_LSA_PPTY.PROPERTY_ID = PS_RE_LS_PPTY.PROPERTY_ID AND PS_RE_LSA_PPTY.ASSET_ID = PS_RE_LS_PPTY.ASSET_ID AND PS_RE_LS_PPTY.EXISTING_ASSET = 'Y')

Failed SQL stmt: UPDATE PS_RE_LSA_PPTY SET PS_RE_LSA_PPTY.EXISTING_ASSET = 'Y' WHERE PS_RE_LSA_PPTY.EXISTING_ASSET = 'N' AND ( (200,0)

Message Reason: File: e:\pt85517b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ','.

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