PC_PO_TO_PC Process ABENDED At Step PC_PO_TO_PC.21000000.UPDATE2 (SQL) -- RC = 8601 (108,524) (Doc ID 2190675.1)

Last updated on OCTOBER 07, 2016

Applies to:

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

Symptoms

On : 9.2 version, Other

In SQL Server Environment, PC_PO_TO_PC fails with the following abend

Process 3260936 ABENDED at Step PC_PO_TO_PC.21000000.UPDATE2 (SQL) -- RC = 8601 (108,524)


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

File: e:\pt85505c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'RQT'.
[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 'W
Failed SQL stmt: UPDATE PS_PC_RES_RQ_TAO4 RQT SET RQT.RESOURCE_AMOUNT=( SELECT (RQT1.RESOURCE_AMOUNT+RVT.VAT_AMT- RVT.VAT_RCVRY_AMT - RVT.VAT_REBATE_AMT) FROM PS_PC_RES_RQ_TAO4 RQT1 ,PS_REQ_LN_DIST_VAT RVT WHERE RQT1.REQ_ID=RVT.REQ_ID AND RQT1.BUSINESS_UNIT_PO=RVT.BUSINESS_UNIT AND RVT.VAT_NRCVR_PRO_FLG='Y' AND RQT1.REQ_LINE_NBR=RVT.LINE_NBR AND RQT1.REQ_SCHED_NBR=RVT.SCHED_NBR AND RQT1.REQ_DISTRIB_NBR=RVT.DISTRIB_LINE_NUM AND RQT1.PROCESS_INSTANCE=3260936 AND RQT1.PROCESS_INSTANCE=RQT.PROCESS_INSTANCE AND RQT1.REQ_ID=RQT.REQ_ID AND RQT1.BUSINESS_UNIT_PO=RQT.BUSINESS_UNIT_PO AND RQT1.REQ_LINE_NBR=RQT.REQ_LINE_NBR AND RQT1.REQ_SCHED_NBR=RQT.REQ_SCHED_NBR AND RQT1.REQ_DISTRIB_NBR=RQT.REQ_DISTRIB_NBR),RQT.FOREIGN_AMOUNT=( SELECT (RQT2.FOREIGN_AMOUNT+RVT1.VAT_AMT_BASE- RVT1.VAT_RCVRY_AMT_BSE - RVT1.VAT_REBATE_AMT_BSE) FROM PS_PC_RES_RQ_TAO4 RQT2 ,PS_REQ_LN_DIST_VAT RVT1 WHERE RQT2.REQ_ID=RVT1.REQ_ID AND RQT2.BUSINESS_UNIT_PO=RVT1.BUSINESS_UNIT AND RVT1.VAT_NRCVR_PRO_FLG='Y' AND RQT2.REQ_LINE_NBR=RVT1.LINE_NBR AND RQT2.REQ_SCHED_NBR=RVT1.SCHED_NBR AND RQT2.REQ_DISTRIB_NBR=RVT1.DISTRIB_LINE_NUM AND RQT2.PROCESS_INSTANCE=3260936 AND RQT2.PROCESS_INSTANCE=RQT.PROCESS_INSTANCE AND RQT2.REQ_ID=RQT.REQ_ID AND RQT2.BUSINESS_UNIT_PO=RQT.BUSINESS_UNIT_PO AND RQT2.REQ_LINE_NBR=RQT.REQ_LINE_NBR AND RQT2.REQ_SCHED_NBR=RQT.REQ_SCHED_NBR AND RQT2.REQ_DISTRIB_NBR=RQT.REQ_DISTRIB_NBR) WHERE RQT.PROCESS_INSTANCE=3260936 AND EXISTS( SELECT 'X' FROM PS_REQ_LN_DIST_VAT RVT2 WHERE RQT.REQ_ID=RVT2.REQ_ID AND RQT.BUSINESS_UNIT_PO=RVT2.BUSINESS_UNIT AND RVT2.VAT_NRCVR_PRO_FLG='Y' AND RQT.REQ_LINE_NBR = RVT2.LINE_NBR AND RQT.REQ_SCHED_NBR = RVT2.SCHED_NBR AND RQT.REQ_DISTRIB_NBR = RVT2.DISTRIB_LINE_NUM )

Process 3260936 ABENDED at Step PC_PO_TO_PC.21000000.UPDATE2 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 22.58.16 2016-09-19

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Configure VAT in Purchasing.
2) Create a project and activity.
3) Create requisition with two lines against the activity. Ensure there is recoverable VAT calculated for the requisition lines.
4) Run PC_PO_TO_PC.


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