My Oracle Support Banner

App Engine PC_FND_DIST Failing With Oracle Db Specific SQL (Doc ID 2450226.1)

Last updated on FEBRUARY 01, 2019

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

App Engine PC_FND_DIST failing with Oracle db specific SQL  
 

ERROR
-----------------------
File: e:\pt85606b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'SRC'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180 Failed SQL stmt: UPDATE PS_PC_FND_TA24 SRC SET SRC.RESOURCE_AMOUNT = 0, SRC.FOREIGN_AMOUNT = 0, SRC. RESOURCE_AMOUNT2 = 0, SRC.FOREIGN_AMOUNT2 = 0 WHERE SRC.PROCESS_INSTANCE = 150105 AND SRC.BUSINESS_U NIT = 'EGV01' AND SRC.PROJECT_ID = 'C_BRIDGE' AND SRC.RULE_ACTIVITY_ID = 'DESIGN' AND SRC.TARGET_GRO UP_ID = '1' AND PROCESS_STATUS IN ('N', 'O') AND ' ' = 'Y'
BUSINESS IMPACT

Process xxxxxx ABENDED at Step PC_FND_DIST.NETADJ.Step03 (SQL) -- RC = 8601

xxxxxx PC_FND_DIST NETADJ Step03 SQL 8601

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PC_FND_DIST
2. Error message is generated.

Changes

 < Internal Only

Documents:

Replication Steps

Unit Testing

Code Change

Internal Only >

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.