CHRS Knowledge Base

TL Troubleshooting Guide

Updated on

The purpose of this document is to assist campus users with troubleshooting items that arise in TL. 

Employee

Student Employees unable to enter time for 4/30/2025 on 5/1/2025? 

This issue can be caused by various factors. Before submitting a ServiceNow ticket, please review the following:

  • Row Security Permission List
  • Grace Period setup

Timekeeper

Timekeeper is unable to enter CTO/ADO for an employee.

This is typically caused by an issue with the Dynamic Group setup. Review the Dynamic Group setup associated with the Timekeeper before submitting a ticket. 

Approver

Error message encountered when trying to approve time: [Process: ‘TLPayableTime’]: there is no transaction record at level -1 for this approval process.

When users encounter this error, there are two available options to resolve it:

  1. Begin by identifying the employee(s) experiencing the issue and have CHRS Operations use Monitor Approvals to restart the workflow process, allowing the manager to go in and approve. A ServiceNow ticket will be required for this request.
  2. Instruct the manager to access the Timesheet and click the Submit button. This will change the Payable Status to "Approved," allowing it to be processed by the PIP system.

Payroll/Admin

When entering an adjustment on a timesheet, the adjustment is not picked up by the PIP file.

Until sufficient data is available in CHRS, adjustments must be made both on the Timesheet and in PIMS.

ADO did not generate for an employee.

Begin by checking whether the employee is assigned to a work schedule and if the holiday falls on a scheduled off day. To do this, go to the Assign Work Schedule page and click Show Schedule to view the details. For any off days, ensure the Off Shift checkbox is selected.

Campuses can directly update the Personal Schedule, but any changes to Predefined Schedules must be requested through a ServiceNow ticket. Once any necessary schedule adjustments are made, update the TL Earliest Change Date (ECD) to the holiday date and run Time Admin.

If the schedule is already correct and no updates are needed, the ADO may not have generated simply because Time Admin was not run for that period. In that case, update the ECD to the holiday date and run Time Admin.

 For any off days, ensure the Off Shift checkbox is selected.

Errors and Exceptions

Timesheet Exceptions

Exceptions are triggered when reported time is either inaccurate or does not align with the defined rules. Each exception is assigned a severity level that determines its cleanup priority. Low and medium severity exceptions are automatically processed by Time Admin, allowing payable time to be created. High severity exceptions, however, are ignored by Time Admin until they are either resolved or manually allowed.

These messages may differ based on the scenario, as they are only examples of what might appear. If the message you received is not listed, a ServiceNow ticket may be required.

Inactive Time Reporter Status

Exception Definition ID: TLX00030

Exception Severity: High

Next Steps: Verify that the TIME_RPTG_STATUS of the time reporter on the TL_EMPL_DATA record is 'Active', as of the date reported.

Invalid Taskgroup

Exception Definition ID: TLX00040

Exception Severity: High

Next Steps: Verify that the Taskgroup is in the TL_TASKGRP_TB as of the date reported.

Invalid Task Profile

Exception Definition ID: TLX00060

Exception Severity: High

Next Steps: Verify that the Task Profile ID is in the TL_TSKPRF table as of the date reported.

Task Profile not in Taskgroup

Exception Definition ID: TLX00080

Exception Severity: High

Next Steps: Verify that the Task Profile ID is in the TL_TSKGRP_PRFL table for the task group to which the time reporter has been borrowed as of the date reported.

Task Values Required

Exception Definition ID: TLX00090

Exception Severity: High

Next Steps: Verify that either all or none of the required task elements of the task template have been reported.

Invalid Task Value

Exception Definition ID: TLX00100

Exception Severity: High

Next Steps: Verify that the time reporter does not report task elements that are not available on the task template.

Invalid Combo Code

Exception Definition ID: TLX00110

Exception Severity: High

Next Steps: Verify that the Combo Code reported exists in the TL_COMM_ACCT_VW when the TASK_PROFILE_ID is not reported, the Combo Code is a required field on the task template. 

Invalid HR Business Unit

Exception Definition ID: TLX00120

Exception Severity: High

Next Steps: Verify that the BUSINESS_UNIT reported exists in the BUS_UNIT_TBL_HR table when the TASK_PROFILE_ID is not reported and BUSINESS_UNIT is a required field on the task template.

Invalid Value for Task Templt

Exception Definition ID: TLX00130

Exception Severity: High

Next Steps: Verify that BUSINESS_UNIT_PC is not reported when PS/Projects is not installed.  

Invalid Business Unit PF

Exception Definition ID: TLX00141

Exception Severity: High

Next Steps: Verify that the BUSINESS_UNIT_PF reported exists in the BUS_UNIT_TBL_PF table when TASK_PROFILE_ID is not reported, and PS/Projects is not installed.

Invalid Company

Exception Definition ID: TLX00150

Exception Severity: High

Next Steps: Verify that the COMPANY reported exists in the COMPANY_TBL when TASK_PROFILE_ID is not reported. 

Invalid Location

Exception Definition ID: TLX00160

Exception Severity: High

Next Steps: Verify that the LOCATION reported exists in the TL_LOCATION_VW when TASK_PROFILE_ID is not reported.

Invalid Job Code

Exception Definition ID: TLX00170

Exception Severity: High

Next Steps: Verify that the JOBCODE reported exists in the TL_JOBCODE_VW when TASK_PROFILE_ID is not reported.

Invalid Position Number

Exception Definition ID: TLX00180

Exception Severity: High

Next Steps: Verify that the JOBCODE reported exists in the TL_JOBCODE_VW when TASK_PROFILE_ID is not reported.

Invalid Customer

Exception Definition ID: TLX00190

Exception Severity: High

Next Steps: Verify that the CUSTOMER reported exists in the TL_CUSTOMER table when TASK_PROFILE_ID is not reported.

Invalid Department

Exception Definition ID: TLX00200

Exception Severity: High

Next Steps: Verify that the DEPTID reported exists in the TL_DEPT_TBL_VW when TASK_PROFILE_ID is not reported.

Invalid Product

Exception Definition ID: TLX00211

Exception Severity: High

Next Steps: Verify that the PRODUCT reported exists in the PRODUCT_TBL when TASK_PROFILE_ID is not reported and the COMMIT_ACCTG_FLG on the task template is 'N'

Invalid Task

Exception Definition ID: TLX00220

Exception Severity: High

Next Steps: Verify that the TASK reported exists in the TL_TASK table when TASK_PROFILE_ID is not reported.

Invalid Activity ID

Exception Definition ID: TLX00230, TLX00231, TLX00232

Exception Severity: High

Next Steps: 

  • Verify that the ACTIVITY_ID reported exists in the TL_PROJ_ACTV_VW when TASK_PROFILE_ID is not reported and PS/Projects is installed.
  • Verify that the ACTIVITY_ID reported exists in the TL_ACTIVITY table when TASK_PROFILE_ID is not reported and both PS/Projects and PS/EPM are not installed.
  • Verify that the ACTIVITY_ID reported exists in the TL_FS_ACTV_VW when TASK_PROFILE_ID is not reported, PS/EPM is installed, and PS/Projects is not installed.
Invalid Value for Task Templt

Exception Definition ID: TLX00240

Exception Severity: High

Next Steps: Verify that RESOURCE_TYPE is not reported when PS/Projects is not installed.

Invalid Resource Type

Exception Definition ID: TLX00241

Exception Severity: High

Next Steps: Verify that the RESOURCE_TYPE reported exists in TL_PROJ_RTYPE_V when TASK_PROFILE_ID is not reported and PS/Projects is installed.

Invalid Project ID

Exception Definition ID: TLX00251, TLX00254

Exception Severity: High

Next Steps:

  • Verify that the PROJECT_ID reported exists in the TL_PROJECT table when TASK_PROFILE_ID is not reported and the COMMIT_ACCTG_FLG on task template is 'N' and PS/Projects is not installed.
  • Verify that the PROJECT_ID reported exists in the TL_PROJ_TEAM_DVW when TASK_PROFILE_ID is not reported , COMMIT_ACCTG_FLG on task template is 'N', PS/Projects is installed, and ENFORCE on the PROJECT table is 'Y'.
Invalid Resource Category

Exception Definition ID: TLX00261, TLX00262

Exception Severity: High

Next Steps:

  • Verify that the RESOURCE_CATEGORY reported exists in the TL_PROJ_CATG_V2 when TASK_PROFILE_ID is not reported, PS/Projects is installed, and CATEGORY_EDIT on BUS_UNIT_TBL_PC is 'REL' indicating that Resource Category is related to Resource Type.

  • Verify that the RESOURCE_CATEGORY reported exists in TL_PROJ_CATG_VW when TASK_PROFILE_ID is not reported, PS/Projects is installed and CATEGORY_EDIT on BUS_UNIT_TBL_PC is 'IND' indicating that Resource Category is independent of Resource Type.

Invalid Value for Task Templt

Exception Definition ID: TLX00270

Exception Severity: High

Next Steps: Verify that RESOURCE_SUB_CAT is not reported when TASK_PROFILE_ID is not reported and PS/Projects is not installed.

Invalid Resource Subcategory

Exception Definition ID: TLX00280, TLX00281

Exception Severity: High

Next Steps:

  • Verify that the RESOURCE_SUB_CAT reported exists in TL_PROJ_SUB_V2 when TASK_PROFILE_ID is not reported, PS/Projects is installed and SUBCATEGORY_EDIT on BUS_UNIT_TBL_PC is 'REL' indicating that Resource Subcategory is related to Resource Category.
  • Verify that the RESOURCE_SUB_CAT reported exists in TL_PROJ_SUB_VW when TASK_PROFILE_ID is not reported, PS/Projects is installed and SUBCATEGORY_EDIT on BUS_UNIT_TBL_PC is 'IND' indicating that Resource Subcategory is independent of Resource Category.
Required Value for Task Templt

Exception Definition ID: TLX00310, TLX00320

Exception Severity: High

Next Steps:

  • Verify that BUSINESS_UNIT is reported when TASK_PROFILE_ID is not reported and DEPTID, LOCATION and JOBCODE are required fields on the task template.
  • Verify that BUSINESS_UNIT_PC is reported when TASK_PROFILE_ID is not reported, PS/Projects is installed, COMMIT_ACCTG_FLG is 'N' and PROJECT is a required field on the task template.
Required Value for Task Templt

Exception Definition ID: TLX00340

Exception Severity: High

Next Steps: Verify that BUSINESS_UNIT_PF is reported when TASK_PROFILE_ID is not reported, PS/Projects is not installed, COMMIT_ACCTG_FLG is 'Y', PS/EPM is installed and ACTIVITY_ID is a required field on the task template.

Invalid Value for Task Templt

Exception Definition ID: TLX00350, TLX00361, TLX00370, TLX00380, TLX00390

Exception Severity: High

Next Steps:

  • Verify that POSITION_NBR is not reported when POSITION_MGMT on INSTALLATION table is 'N'.
  • Verify that PROJECT_ID is not reported when both PS/Projects and PS/EPM are installed, COMMIT_ACCTG_FLG is 'N', and both BUSINESS_UNIT_PF and ACTIVITY are required fields on the task template.
  • Verify that RESOURCE_CATEGORY is not reported when PS/Projects is installed but PROJECT is not available on the task template.
  • Verify that RESOURCE_SUB_CAT is not reported when PS/Projects is installed and PROJECT is not available on task template.
  • Verify that RESOURCE_TYPE is not reported when PS/Projects is installed and PROJECT is not available on the task template.
Invalid entry of Task Elements

Exception Definition ID: TLX00400

Exception Severity: High

Next Steps: Verify that no individual Task Elements are reported when TASK_PROFILE_ID is reported.

Invalid Values for Task Templt

Exception Definition ID: TLX00410

Exception Severity: High

Next Steps: Verify that both BUSINESS_UNIT_PC and BUSINESS_UNIT_PF are not reported at the same time.

Invalid TRC

Exception Definition ID: TLX00420 

Exception Severity: High

Next Steps: Verify that the reported TRC exists in the TL_TRC_TBL.

TRC is not in TRC Program

Exception Definition ID: TLX00440

Exception Severity: High

Next Steps: Verify that the TRC is in the TRC Program to which the time reporter is affiliated as of the date reported.

Quantity exceeds TRC limits

Exception Definition ID: TLX00450

Exception Severity: High

Next Steps: Verify that the TL_QUANTITY reported is within the limits specified by the MIN_QTY and the MAX_QTY on the TL_TRC_TBL.

Invalid Comp Rate Code Type

Exception Definition ID: TLX00480, TLX00490, TLX00500, TLC00510

Exception Severity: High

Next Steps: 

  • Verify that the COMP_RATECD reported is neither of 'Percent' type nor of 'Points' type.
  • Verify that when both Hours type TRC and COMP_RATECD are reported, the COMP_RATECD is either 'Hourly Flat Rate (HF)' type or 'Hourly Rate (HR)' type.
  • Verify that when both Amount type TRC and COMP_RATECD are reported, COMP_RATECD is of 'Flat Amount (FA)' type.
  • Verify that when a Units type TRC is reported, no COMP_RATECD is reported.
TRC needed for Comp Rate Code

Exception Definition ID: TLX00520

Exception Severity: High

Next Steps: Verify that a TRC is reported when a COMP_RATECD is reported.

Invalid Comp Rate Code

Exception Definition ID: TLX00530

Exception Severity: Medium

Next Steps: Verify that if a COMP_RATECD is reported, it is a valid COMP_RATECD

Invalid Country

Exception Definition ID: TLX00570

Exception Severity: High

Next Steps: Verify that the COUNTRY reported in Elapsed Time is in the COUNTRY_TBL.

Invalid Override Reason Code

Exception Definition ID: TLX00620

Exception Severity: High

Next Steps: Verify that the OVERRIDE_RSN_CD reported in Elapsed Time is in the TL_OVRD_RSN_TBL.

Invalid Rule Element #

Exception Definition ID: TLX00640, TLX00650, TLX00660, TLX00670, TLX00680

Exception Severity: High

Next Steps: Verify that the RULE_ELEMENT_# reported is in the TL_RULE_ELEMENT# table.

Replace # with 1, 2, 3, 4, or 5 depending on the error message. 

Invalid Reported Taskgroup

Exception Definition ID: TLX00830

Exception Severity: High

Next Steps: Validate that the Commitment Accounting Flag on the time reporter's borrowed Taskgroup matches the Commitment Accounting Flag of the Department assigned in JOB, when Taskgroup is reported.

Invalid User Field #

Exception Definition ID: TLX00840, TLX00850, TLX00860, TLX00870, TLX00880

Exception Severity: High

Next Steps: Validate that the USER_FIELD_# reported exists on the TL_USER_FIELD_# table.

Replace # with 1, 2, 3, 4, or 5 depending on the error message. 

More than 24 hours reported

Exception Definition ID: TLX01540

Exception Severity: Medium

Next Steps: More than 24 hours cannot be reported for an Hours type TRC. 

QTY cannot be zero

Exception Definition ID: TLX01550, TLX1560, TLX1570, TLX1580

Exception Severity: High

Next Steps:

  • Validate that TL_QUANTITY is zero when an Amount type TRC is reported and the COMP_RATECD reported is of 'Flat Amount' type.
  • Validate that TL_QUANTITY is not zero when an Hours/Unit type TRC is reported.
  • Validate that TL_QUANTITY is not zero when an Amount type TRC is reported and no COMPRATE_CD is reported.
  • Validate that TL_QUANTITY is not zero when an Amount type TRC is reported and COMPRATE_CD reported is not of 'Flat Amount' type.
Cannot report Override Rate

Exception Definition ID: TLX01590

Exception Severity: High

Next Steps: Validate that OVERRIDE_RATE is not reported along with an Amount type TRC.

Invalid Time Reporter

Exception Definition ID: TLX01600

Exception Severity: High

Next Steps: The reported time is earlier than the Time and Labor enrollment date.

Invalid Comp Rate Code

Exception Definition ID: TLX01630

Exception Severity: High

Next Steps: The Comp Rate Code reported has a rate type equal to points and is not valid.

Invalid TRC

Exception Definition ID: TLX01640

Exception Severity: High

Next Steps: The reported TRC is not valid for time entry. The TRC used is valid for Rules generated time only.

TRC not valid for Punch Time

Exception Definition ID: TLX01650

Exception Severity: High

Next Steps: The TRC reported is not a hours type TRC. Only a hours type TRC can be used to report punch time.

TRC associated with comp/leave

Exception Definition ID: TLX01660

Exception Severity: Medium

Next Steps: The TRC reported is associated with compensation / leave indicator and is invalid to use for reporting punch time.

HR BU not mapped to GL BU

Exception Definition ID: TLX01670

Exception Severity: High

Next Steps: The reported HR Business unit is not mapped to a GL Business Unit.

The reported TRC is not valid for time entry. The TRC used is valid for Absence generated time only.

Exception Definition ID: TLX01690

Exception Severity: High

Next Steps: Warns the user that absence event information can only be reported in Absence module.

Time is reported for Full day Absence.?

Exception Definition ID: TLX01700

Exception Severity: Medium

Next Steps: Full day absence exists and there is a reported time.

Partial absence reported and also Reported Partial Punch Time.

Exception Definition ID: TLX01710

Exception Severity: Low

Next Steps: Triggers only if punch time of SCH source exists for the days of partial absence and the Workgroup is configured to Create Partial Work Hours. This is to warn the user that regeneration of reported time did not adjust the punch scheduled time.

Reported time in prior period

Exception Definition ID: TLX01770

Exception Severity: Medium

Next Steps: Validate if time reporter has reported time in prior period

Reported time in future period

Exception Definition ID: TLX01780

Exception Severity: Medium

Next Steps: Validate if time reporter has reported time in future period

Reported time in prior year

Exception Definition ID: TLX01790

Exception Severity: Medium

Next Steps: Validate if time reporter has reported time in prior year.

Student award balance exceeded

Exception Definition ID: CSUX004

Exception Severity: Medium

Next Steps: Hours entered exceed the remaining student award balance.

Long IN punch > 12 hours

Exception Definition ID: CSUX100

Exception Severity: High

Next Steps: Employee has worked more than 12 hours without clocking out, adjustments may be needed. 

Student > 40 hours for week

Exception Definition ID: CSUX101

Exception Severity: High

Next Steps: Student employee has worked more than 40 hours in a week, adjustments may be needed. 

Long MEAL punch > 1.25 hrs

Exception Definition ID: CSUX102

Exception Severity: Medium

Next Steps: Employee has taken a break longer than 1.25 hours, adjustments may be needed. 

No MEAL after 6 hours

Exception Definition ID: CSUX103

Exception Severity: Medium

Next Steps: Employee has worked more than 6 hours without taking lunch, adjustments may be needed. 

All Day Shift

Exception Definition ID: CSUX104

Exception Severity: Medium

Next Steps: N/A

CTO with Shift

Exception Definition ID: CSUX105

Exception Severity: Medium

Next Steps: N/A

ETO Not Taken on a Holiday

Exception Definition ID: CSUX106

Exception Severity: High

Next Steps: Equivalent Time Off has been reported on a day which is not a holiday, adjustments may be needed.

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) TL Frequently Asked Questions (FAQ)
Next Article (job aid) TL Delivered Queries for CHRS
Do you need an article? Contact Us