My Oracle Support Banner

ETL 9.2 Time And Labor Error When Employee Enter Punch Out Time (Doc ID 2276907.1)

Last updated on APRIL 17, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On 9.2 Tools 8.55.11

Actual Behavior
--------------------------
Error Position: 0
  Return: 8601 - [Microsoft][SQL Server Native Client 10.0]Prepared statement is not a cursor-specification (SQLSTATE 24000) 0
  Statement: SELECT ROUND(DATEDIFF(MINUTE,:1, :2) / 60.0, 5) FROM PS_TL_INSTALLATION
  Original Statement: SELECT %ROUND(ÚTETIMEDIFF(Útetimein(:1), Útetimein(:2)) / 60.0, 5) FROM PS_TL_INSTALLATION


Expected Behavior
-----------------------------------
There should not be any error.

Steps to Replicate
-------------------------
Scenario
1. Employee uses Web Clock (Punch In) – Successfully
2. Minutes later navigates back to Web Clock to (Punch out)
  Error message received
3. Manager navigates to MSS > reported time for employee in question.
4. Enters an out time for the employee’s punch in then clicks the submit button
  Error message received

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.