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 laterInformation 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:
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 |