PO_POCALC Abends at Step PO_POCALC.VS9200.UPDSTGU2 (SQL) with Syntax Error after Applying SCM Bundles 25-27 (Doc ID 1597062.1)

Last updated on JANUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

After applying bundles 25 thru 27, PO Calc (PO_POCALC) abends when run on SQL Server with:

File: e:\pt85307c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '('. [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 not Failed SQL stmt: UPDATE PS_PO_STG_UD_T4 SET (UNIT_PRC_TOL ,UNIT_PRC_TOL_L,EXT_PRC_TOL,EXT_PRC_TOL_L) = ( SELECT A.UNIT_PRC_TOL ,A.UNIT_PRC_TOL_L ,A.EXT_PRC_TOL ,A.EXT_PRC_TOL_L FROM PS_ITM_VNDR_UOM_PR A WHERE A.INV_ITEM_ID = PS_PO_STG_UD_T4.INV_ITEM_ID AND A.SETID = PS_PO_STG_UD_T4.ITM_SETID AND A.UN IT_OF_MEASURE = PS_PO_STG_UD_T4.UNIT_OF_MEASURE AND A.VENDOR_SETID = PS_PO_STG_UD_T4.VENDOR_SETID AN D A.VENDOR_ID = PS_PO_STG_UD_T4.VENDOR_ID AND A.VNDR_LOC= PS_PO_STG_UD_T4.VNDR_LOC AND A.CURRENCY_CD

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