The purpose of this document is to assist campus users with troubleshooting items that arise in TL.
Employee
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
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
When users encounter this error, there are two available options to resolve it:
- 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.
- 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
In the case that there is time reported for dates after the employee’s termination date, and the termination date is not accurate, update the termination date and then update the Time Reporter Data (TRD) inactivation date to reflect the effective date of the termination.
Until sufficient data is available in CHRS, adjustments must be made both on the Timesheet and in PIMS.
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.
Errors and 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.
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.
Exception Definition ID: TLX00040
Exception Severity: High
Next Steps: Verify that the Taskgroup is in the TL_TASKGRP_TB as of the date reported.
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.
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.
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.
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.
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.
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.
Exception Definition ID: TLX00130
Exception Severity: High
Next Steps: Verify that BUSINESS_UNIT_PC is not reported when PS/Projects is not installed.
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.
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.
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.
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.
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.
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.
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.
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'
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.
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.
Exception Definition ID: TLX00240
Exception Severity: High
Next Steps: Verify that RESOURCE_TYPE is not reported when PS/Projects is not installed.
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.
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'.
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.
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.
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.
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.
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.
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.
Exception Definition ID: TLX00400
Exception Severity: High
Next Steps: Verify that no individual Task Elements are reported when TASK_PROFILE_ID is reported.
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.
Exception Definition ID: TLX00420
Exception Severity: High
Next Steps: Verify that the reported TRC exists in the TL_TRC_TBL.
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.
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.
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.
Exception Definition ID: TLX00520
Exception Severity: High
Next Steps: Verify that a TRC is reported when a COMP_RATECD is reported.
Exception Definition ID: TLX00530
Exception Severity: Medium
Next Steps: Verify that if a COMP_RATECD is reported, it is a valid COMP_RATECD
Exception Definition ID: TLX00570
Exception Severity: High
Next Steps: Verify that the COUNTRY reported in Elapsed Time is in the COUNTRY_TBL.
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.
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.
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.
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.
Exception Definition ID: TLX01540
Exception Severity: Medium
Next Steps: More than 24 hours cannot be reported for an Hours type TRC.
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.
Exception Definition ID: TLX01590
Exception Severity: High
Next Steps: Validate that OVERRIDE_RATE is not reported along with an Amount type TRC.
Exception Definition ID: TLX01600
Exception Severity: High
Next Steps: The reported time is earlier than the Time and Labor enrollment date.
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.
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.
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.
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.
Exception Definition ID: TLX01670
Exception Severity: High
Next Steps: The reported HR Business unit is not mapped to a GL Business Unit.
Exception Definition ID: TLX01690
Exception Severity: High
Next Steps: Warns the user that absence event information can only be reported in Absence module.
Exception Definition ID: TLX01700
Exception Severity: Medium
Next Steps: Full day absence exists and there is a reported 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.
Exception Definition ID: TLX01770
Exception Severity: Medium
Next Steps: Validate if time reporter has reported time in prior period
Exception Definition ID: TLX01780
Exception Severity: Medium
Next Steps: Validate if time reporter has reported time in future period
Exception Definition ID: TLX01790
Exception Severity: Medium
Next Steps: Validate if time reporter has reported time in prior year.
Exception Definition ID: CSUX004
Exception Severity: Medium
Next Steps: Hours entered exceed the remaining student award balance.
Exception Definition ID: CSUX100
Exception Severity: High
Next Steps: Employee has worked more than 12 hours without clocking out, adjustments may be needed.
Exception Definition ID: CSUX101
Exception Severity: High
Next Steps: Student employee has worked more than 40 hours in a week, adjustments may be needed.
Exception Definition ID: CSUX102
Exception Severity: Medium
Next Steps: Employee has taken a break longer than 1.25 hours, adjustments may be needed.
Exception Definition ID: CSUX103
Exception Severity: Medium
Next Steps: Employee has worked more than 6 hours without taking lunch, adjustments may be needed.
Exception Definition ID: CSUX104
Exception Severity: Medium
Next Steps: N/A
Exception Definition ID: CSUX105
Exception Severity: Medium
Next Steps: N/A
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