PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PeopleTools 8.54.36 app:8.9 in Tree Viewer when clicked on Search button on the search page:

File: \pt85436b-retail\peopletools\src\psppr\ramget.cppSQL error. Stmt #: 686 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22008) 241

Failed SQL stmt: SELECT COUNT ( DISTINCT TREE_NAME + SETID + SETCNTRLVALUE + EFFDT + (CONVERT(CHAR(10),EFFDT,121)) + DESCR + TREE_CATEGORY + TREE_STRCT_ID + VALID_TREE + NODE_FIELDNAME + DTL_FIELDNAME ) AS COUNT_KEYS FROM PSTREEDEFVWR_VW 

What causes this error? We are using SQL Server 2016.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center