Project-Processing Status Link Process ABENDED at Step PC_STAT_LINK.ProjStat.Step01 (Do Select) -- RC = 8010 - Invalid column name 'SYSDATE ' (Doc ID 2131720.1)

Last updated on MAY 18, 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

Microsoft SQL Server.

When running the delivered process Project-Processing Status Link PC_STAT_LINK App Engine
the following error occurs.

ERROR
-----------------------
When running the delivered process Project-Processing Status Link PC_STAT_LINK App Engine, we are getting a No Success
Process 23101 ABENDED at Step PC_STAT_LINK.ProjStat.Step01 (Do Select) -- RC = 8010

File: e:\pt85418b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SYSDATE '. Failed SQL stmt: SELECT A.BUSINESS_UNIT , A.PROJECT_ID , (CONVERT(CHAR(10),A.EFFDT,121)) , A.EFFSEQ , A.PROJECT_STATUS FROM PS_PROJECT_STATUS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PROJECT_ST ATUS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.EFFDT <= SYSDAT E) AND A.EFFSEQ = ( SELECT MAX(B.EFFSEQ) FROM PS_PROJECT_STATUS B WHERE A.BUSINESS_UNIT = B.BUSINESS _UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.EFFDT = A.EFFDT) AND NOT EXISTS ( SELECT 'X' FROM PS_PRO JECT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.EFF_STATUS = 'T

This occurs in our Demo environment which is 9.2 Image 12, Peopletools 8.54.09. We are running on MicroSoft SQL, not Oracle.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Project Costing > Utilities > Project-Processing Status Link

 

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