EAR9.2: Upgrade to 9.2 PTIADATACONV Application Engine ABENDED Step UPG_AR.ARC40 (Doc ID 1571040.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version


On upgrading to FSCM 9.2, the Data Conversion steps at UPG_AR.ARC40 are failing in these:

  1. UPG_AR.ARC40.REMSEWS34(SQL)
  2. UPG_AR.ARC40.REMSEWS5 (SQL)
  3. UPG_AR.ARC40.REMSEWS6 (SQL)

During upgrade from 9.1 to 9.2 PTIADATACONV Application Engine ABENDED at Step UPG_PC.PCZ02.Step08 (PeopleCode)
Data Conversion AE PTIADATACONV ABENDED at Step UPG_AR.ARC40.REMSEWS3 (SQL) with the following error

ERROR
--------

File: e:\pt85304c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'Z'.
[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
Failed SQL stmt: UPDATE PS_WS_ITEM Z SET Z.REMIT_ADDR_SEQ_NUM = ( SELECT DISTINCT B.REMIT_ADDR_SEQ_NUM FROM PS_VENDOR_LOC B , PS_VENDOR A , PS_CUSTOMER C , PS_SET_CNTRL_REC S , PS_WS_ITEM WS WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.DEFAULT_LOC = B.VNDR_LOC AND A.SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID AND B.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.SETID = S.SETID AND S.SETCNTRLVALUE = WS.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER' AND WS.ENTRY_USE_ID IN ('MT-08', 'MT-09') AND A.SETID = WS.REMIT_SETID AND A.VENDOR_ID = WS.REMIT_VENDOR AND B.SETID = WS.REMIT_SETID AND B.VENDOR_ID = WS.REMIT_VENDOR AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_VENDOR_LOC D WHERE D.SETID = A.SETID AND D.VENDOR_ID = A.VENDOR_ID AND D.VNDR_LOC = A.DEFAULT_LOC AND D.EFFDT ' ' AND WS.REMIT_VENDOR <> ' ' AND WS.ENTRY_USE_ID IN ('MT-08', 'MT-09')) AND Z.WS_BU = WS.WS_BU AND Z.WS_ID = WS.WS_ID AND Z.SUB_GROUP_ID = WS.SUB_GROUP_ID AND Z.BUSINESS_UNIT = WS.BUSINESS_UNIT AND Z.CUST_ID = WS.CUST_ID AND Z.ITEM = WS.ITEM AND Z.ITEM_LINE = WS.ITEM_LINE AND Z.WS_SEQ = WS.WS_SEQ) WHERE Z.ENTRY_USE_ID IN ('MT-08', 'MT-09') AND EXISTS( SELECT 'X' FROM PS_VENDOR_LOC B1 , PS_VENDOR A1 , PS_CUSTOMER C1 , PS_SET_CNTRL_REC S1 , PS_WS_ITEM WS1 WHERE A1.SETID = B1.SETID AND A1.VENDOR_ID = B1.VENDOR_ID AND A1.DEFAULT_LOC = B1.VNDR_LOC AND A1.S


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with the upgrade.

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