ETL9.1: Reported Time Update Causes TL_TA000600.CALC_TA.CALCDIFF (SQL) -- RC = 805 (108,524) abend. (Doc ID 1505604.1)

Last updated on MAY 20, 2016

Applies to:

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

Symptoms

Since Bundle 10, Customer has an issue with the hourly timesheet that now causes TimeAdmin to abend at TL_TA000600 - Match Punches.    
  
Process 942 ABENDED at Step TL_TA000600.CALC_TA.CALCDIFF (SQL) -- RC = 805  
  
 TL_TA000600 CALC_TA CALCDIFF SQL 805
  
  REPLICATION STEPS
  =================
1.  Employee enters LUNCH IN and LUNCH OUT punches and SV (saves) status.
 

2.  Employee goes back into timesheet and removes the LUNCH punches, but keeps IN and OUT punch and SUBMITS time.
   After submitting, the lunch rows still exist in TL_RPTD_TIME and the PUNCH_TIME column is NULL.
  

3.  Employee again makes changes - adding Reg and Lunch punches and submits time.  

Eventually some of the rows with the NULL value (PUNCH_TIME), cause TA to abend with Unique constraint.

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