PROJECT HIERARCHY LINK CAUSING A FATAL PEOPLECODE SQL ERROR

(Doc ID 2409812.1)

Last updated on JUNE 11, 2018

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, Inquiry

Oracle specific functions in SQL object causing errors when trying to display Project Heirarchy  

SQL.PC_PROJ_STATUS_SEL contains Oracle specific TO_CHAR and TO_DATE functions.  It should be using PeopleTools Meta SQL

ERROR
-----------------------
Return:  8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'TO_CHAR' is not a recognized built-in function name.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Navigate to Project Costing > Project Definitions > General Information
2.  Open Project 000000000000165 for BU US004
3.  Click on the Project Hierarchy link
4.  Error messages are 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