PC_POADJUST Process ABENDED At Step PC_POADJUST.3INSCCA.COPY_DE2 (SQL) -- RC = 8601

(Doc ID 2339818.1)

Last updated on DECEMBER 18, 2017

Applies to:

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

Symptoms

On : 9.2 version, Commitment Control

PC_POADJUST process ABENDED at Step PC_POADJUST.3INSCCA.COPY_DE2 (SQL) -- RC = 8601

PC_POADJUST process abends after applying bugs 25886153 and 25835679

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

--File: e:\pt85513b-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 'PR'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not Failed SQL stmt: DELETE FROM PS_PC_RES_PA_TA14 PR WHERE PR.PROCESS_INSTANCE = 865371 AND PR.ANALYSIS _TYPE IN ('CCA', 'CAJ') AND EXISTS ( SELECT 'X' FROM PS_PC_RES_PA_TA94 TA9 WHERE PR.PROCESS_INSTANCE = TA9.PROCESS_INSTANCE AND TA9.ANALYSIS_TYPE IN ('CRV', 'CCR') AND PR.BUSINESS_UNIT = TA9.BUSINESS_ UNIT AND PR.PROJECT_ID = TA9.PROJECT_ID AND PR.ACTIVITY_ID = TA9.ACTIVITY_ID AND PR.RESOURCE_AMOUNT = TA9.RESOURCE_AMOUNT ) AND 1=1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PC_POADJUST process.
2. Define Parameter selection on run control
3. Run the process
4. Error message generated.

Changes

 < Internal Only

Documents:

Replication Steps

Unit Testing

Code Change

Internal Only >

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