My Oracle Support Banner

ETL9.2: Fluid Reported Time Audit SQL Error In TL_AUD_RPTTIME.FL.GBL.TL_AUD_RT_WRK.GET_ROWS (Doc ID 2581479.1)

Last updated on FEBRUARY 06, 2020

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When on Time and Labor Work Center attempting to click on Reported Time Audit,
the following error occurs.

ERROR
-----------------------
SQL Error in DescribeCol
TL_AUD_RPTTIME.FL.GBL.TL_AUD_RT_WRK.GET_ROWS.FieldChange PCPC:671 Statement:9


STEPS
-----------------------

1. Navigate to Reported Time Audit
2. Click on Reported Time Audit to get an error

Return: 8603 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'SYSTIMESTAMP'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'SYSTIMESTAMP'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could n

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
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.