Understanding Exceptions and Validations

The following is a list of validations and exceptions, ordered by validation definition ID number. All of these validations can be configured to run in Submit Time and Time Administration. For validations on time reporting elements that are selected to be processed in Submit Time, you can choose not to run these during the Time Administration process to increase performance time.

Note: All exceptions listed in this table are delivered with a high severity level except TLX01700 and TLX01710, which are delivered with a low severity level. If you modify high severity exceptions by selecting the Allowable check box on the Exception Definition page, in some cases payable time is still not created, even though the exception is allowed on the Manage Exceptions page.

See Defining Exceptions, Managing Exceptions.

Nbr	Validation Definition ID	Validation Definition	Validation Comments	Exception Definition ID	Exception Descr.
1	TLX00030	Time Reporting Status Check	Verify that the TIME_RPTG_STATUS of the time reporter on the TL_EMPL_DATA record is 'Active', as of the date reported.	TLX00030	Inactive Time Reporter Status
2	TLX00040	Valid Taskgroup	Verify that the Taskgroup is in the TL_TASKGRP_TB as of the date reported.	TLX00040	Invalid Taskgroup
3	TLX00060	Valid Task Profile ID	Verify that the Task Profile ID is in the TL_TSKPRF table as of the date reported.	TLX00060	Invalid Task Profile
4	TLX00080	Task Prof in Borrowed Tskgrp	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.	TLX00080	Task Profile not in Taskgroup
5	TLX00090	All/ None Reqd Task Elements	Verify that either all or none of the required task elements of the task template have been reported.	TLX00090	Task Values Required
6	TLX00100	Task Elements not allowed	Verify that the time reporter does not report task elements that are not available on the task template.	TLX00100	Invalid Task Value
7	TLX00110	ACCT_CD in TL_COMM_ACCT_VW	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.	TLX00110	Invalid Combo Code
8	TLX00120	BUSINESS_UNIT is Reported	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.	TLX00120	Invalid HR Business Unit
9	TLX00130	BUSINESS_UNIT_PC	Verify that BUSINESS_UNIT_PC is not reported when PS/Projects is not installed.	TLX00130	Invalid Value for Task Templt
10	TLX00141	BUSINESS_UNIT_PF	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.	TLX00141	Invalid Business Unit PF
11	TLX00150	COMPANY	Verify that the COMPANY reported exists in the COMPANY_TBL when TASK_PROFILE_ID is not reported.	TLX00150	Invalid Company
12	TLX00160	LOCATION	Verify that the LOCATION reported exists in the TL_LOCATION_VW when TASK_PROFILE_ID is not reported.	TLX00160	Invalid Location
13	TLX00170	JOBCODE	Verify that the JOBCODE reported exists in the TL_JOBCODE_VW when TASK_PROFILE_ID is not reported.	TLX00170	Invalid Jobcode
14	TLX00180	POSITION_NBR	Verify that the POSITION_NBR reported exists in the POSITION_DATA table when TASK_PROFILE_ID is not reported.	TLX00180	Invalid Position Number
15	TLX00190	CUSTOMER	Verify that the CUSTOMER reported exists in the TL_CUSTOMER table when TASK_PROFILE_ID is not reported.	TLX00190	Invalid Customer
16	TLX00200	DEPTID	Verify that the DEPTID reported exists in the TL_DEPT_TBL_VW when TASK_PROFILE_ID is not reported.	TLX00200	Invalid Department
17	TLX00211	PRODUCT	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'.	TLX00211	Invalid Product
18	TLX00220	TASK	Verify that the TASK reported exists in the TL_TASK table when TASK_PROFILE_ID is not reported.	TLX00220	Invalid Task
19	TLX00230	ACTIVITY_ID	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.	TLX00230	Invalid Activity ID
20	TLX00231	ACTIVITY_ID	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.	TLX00231	Invalid Activity ID
21	TLX00232	ACTIVITY_ID	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.	TLX00232	Invalid Activity ID
22	TLX00240	RESOURCE_TYPE	Verify that RESOURCE_TYPE is not reported when PS/Projects is not installed.	TLX00240	Invalid Value for Task Templt
23	TLX00241	RESOURCE_TYPE	Verify that the RESOURCE_TYPE reported exists in TL_PROJ_RTYPE_V when TASK_PROFILE_ID is not reported and PS/Projects is installed.	TLX00241	Invalid Resource Type
24	TLX00251	PROJECT_ID	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.	TLX00251	Invalid Project ID
25	TLX00254	PROJECT_ID	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'.	TLX00254	Invalid Project ID
26	TLX00260	RESOURCE_CATEGORY	Verify that RESOURCE_CATEGORY is not reported when TASK_PROFILE_ID is not reported and PS/Projects is not installed.	TLX00260	Invalid Value for Task Templt
27	TLX00261	RESOURCE_CATEGORY	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.	TLX00261	Invalid Resource Category
28	TLX00262	RESOURCE_CATEGORY	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.	TLX00262	Invalid Resource Category
29	TLX00270	RESOURCE_SUB_CAT	Verify that RESOURCE_SUB_CAT is not reported when TASK_PROFILE_ID is not reported and PS/Projects is not installed.	TLX00270	Invalid Value for Task Templt
30	TLX00280	RESOURCE_SUB_CAT	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.	TLX00280	Invalid Resource Subcategory
31	TLX00281	RESOURCE_SUB_CAT	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.	TLX00281	Invalid Resource Subcategory
32	TLX00310	Bus Unit Rptd/Other Flds Req	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.	TLX00310	Required Value for Task Templt
33	TLX00320	BUSINESS_UNIT_PC	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.	TLX00320	Required Value for Task Templt
34	TLX00330	BUSINESS_UNIT_PF	Verify that BUSINESS_UNIT_PF is not reported when COMMIT_ACCTG_FLG is 'Y' on the task template and both PS/Projects and PS/EPM are not installed.	TLX00330	Invalid Value for Task Templt
35	TLX00340	BUSINESS_UNIT_PF	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.	TLX00340	Required Value for Task Templt
36	TLX00350	POSITION_NBR	Verify that POSITION_NBR is not reported when POSITION_MGMT on INSTALLATION table is 'N'.	TLX00350	Invalid Value for Task Templt
37	TLX00361	PROJECT_ID	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.	TLX00361	Invalid Value for Task Templt
38	TLX00370	RESOURCE_CATEGORY	Verify that RESOURCE_CATEGORY is not reported when PS/Projects is installed but PROJECT is not available on the task template.	TLX00370	Invalid Value for Task Templt
39	TLX00380	RESOURCE_SUB_CAT	Verify that RESOURCE_SUB_CAT is not reported when PS/Projects is installed and PROJECT is not available on task template.	TLX00380	Invalid Value for Task Templt
40	TLX00390	RESOURCE_TYPE	Verify that RESOURCE_TYPE is not reported when PS/Projects is installed and PROJECT is not available on the task template.	TLX00390	Invalid Value for Task Templt
41	TLX00400	No Tsk Elmnts with Tsk Prof	Verify that no individual Task Elements are reported when TASK_PROFILE_ID is reported.	TLX00400	Invalid entry of Task Elements
42	TLX00410	BUS_UNIT_PC vs BUS_UNIT_PF	Verify that both BUSINESS_UNIT_PC and BUSINESS_UNIT_PF are not reported at the same time.	TLX00410	Invalid Values for Task Templt
43	TLX00420	Valid TRC	Verify that the reported TRC exists in the TL_TRC_TBL.	TLX00420	Invalid TRC
44	TLX00440	TRC is in TRC Program	Verify that the TRC is in the TRC Program to which the time reporter is affiliated as of the date reported.	TLX00440	TRC is not in TRC Program
45	TLX00450	MIN_QTY & MAX_QTY	Verify that the TL_QUANTITY reported is within the limits specified by the MIN_QTY and the MAX_QTY on the TL_TRC_TBL.	TLX00450	Quantity exceeds TRC limits
46	TLX00480	COMP_RATECD	Verify that the COMP_RATECD reported is neither of 'Percent' type nor of 'Points' type.	TLX00480	Invalid Comp Rate Code Type
47	TLX00490	Hours Type TRC & COMP_RATECD	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.	TLX00490	Invalid Comp Rate Code Type
48	TLX00500	Amount Type TRC & COMP_RATECD	Verify that when both Amount type TRC and COMP_RATECD are reported, COMP_RATECD is of 'Flat Amount (FA)' type.	TLX00500	Invalid Comp Rate Code Type
49	TLX00510	Units Type TRC & COMP_RATE_CD	Verify that when a Units type TRC is reported, no COMP_RATECD is reported.	TLX00510	Invalid Comp Rate Code Type
50	TLX00520	COMP_RATECD & TRC Reported	Verify that a TRC is reported when a COMP_RATECD is reported.	TLX00520	TRC needed for Comp Rate Code
51	TLX00530	COMP_RATECD	Verify that if a COMP_RATECD is reported, it is a valid COMP_RATECD.	TLX00530	Invalid Comp Rate Code
52	TLX00560	BILLABLE_IND	Verify that BILLABLE_IND reported in Elapsed Time has the value of either 'Y' or 'N'.	TLX00560	Invalid Billable Indicator
53	TLX00570	COUNTRY	Verify that the COUNTRY reported in Elapsed Time is in the COUNTRY_TBL.	TLX00570	Invalid Country
54	TLX00590	CURRENCY_CD	Verify that the CURRENCY_CD reported in Elapsed Time is in the CURRENCY_CD_TBL.	TLX00590	Invalid Currency Code
55	TLX00600	LOCALITY	Verify that the LOCALITY reported in Elapsed Time is in the LOCAL_TAX_TBL.	TLX00600	Invalid Locality
56	TLX00620	OVERRIDE_RSN_CD	Verify that the OVERRIDE_RSN_CD reported in Elapsed Time is in the TL_OVRD_RSN_TBL.	TLX00620	Invalid Override Reason Code
57	TLX00640	RULE_ELEMENT_1	Verify that the RULE_ELEMENT_1 reported is in the TL_RULE_ELEMENT1 table.	TLX00640	Invalid Rule Element 1
58	TLX00650	RULE_ELEMENT_2	Verify that the RULE_ELEMENT_2 reported is in the TL_RULE_ELEMENT2 table.	TLX00650	Invalid Rule Element 2
59	TLX00660	RULE_ELEMENT_3	Verify that the RULE_ELEMENT_3 reported is in the TL_RULE_ELEMENT3 table.	TLX00660	Invalid Rule Element 3
60	TLX00670	RULE_ELEMENT_4	Verify that the RULE_ELEMENT_4 reported is in the TL_RULE_ELEMENT4 table.	TLX00670	Invalid Rule Element 4
61	TLX00680	RULE_ELEMENT_5	Verify that the RULE_ELEMENT_5 reported is in the TL_RULE_ELEMENT5 table.	TLX00680	Invalid Rule Element 5
62	TLX00740	STATE	Verify that the STATE reported is in the STATE_NAMES_TBL.	TLX00740	Invalid State
63	TLX00830	COMMIT_ACCTG_FLAG vs. USE_DIST	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.	TLX00830	Invalid Reported Taskgroup
64	TLX00840	USER_FIELD_1	Validate that the USER_FIELD_1 reported exists on the TL_USER_FIELD_1 table.	TLX00840	Invalid User Field 1
65	TLX00850	USER_FIELD_2	Validate that the USER_FIELD_2 reported exists on the TL_USER_FIELD_2 table.	TLX00850	Invalid User Field 2
66	TLX00860	USER_FIELD_3	Validate that the USER_FIELD_3 reported exists on the TL_USER_FIELD_3 table.	TLX00860	Invalid User Field 3
67	TLX00870	USER_FIELD_4	Validate that the USER_FIELD_4 reported exists on the TL_USER_FIELD_4 table.	TLX00870	Invalid User Field 4
68	TLX00880	USER_FIELD_5	Validate that the USER_FIELD_5 reported exists on the TL_USER_FIELD_5 table.	TLX00880	Invalid User Field 5
69	TLX01540	More than 24 hours reported	More than 24 hours cannot be reported for an Hours type TRC.	TLX01540	More than 24 hours reported
70	TLX01550	QTY is not zero	Validate that TL_QUANTITY is zero when an Amount type TRC is reported and the COMP_RATECD reported is of 'Flat Amount' type.	TLX01550	QTY must be zero
71	TLX01560	QTY cannot be zero	Validate that TL_QUANTITY is not zero when an Hours/Unit type TRC is reported.	TLX01560	QTY cannot be zero
72	TLX01570	QTY cannot be zero	Validate that TL_QUANTITY is not zero when an Amount type TRC is reported and no COMPRATE_CD is reported.	TLX01570	QTY cannot be zero
73	TLX01580	QTY cannot be zero	Validate that TL_QUANTITY is not zero when an Amount type TRC is reported and COMPRATE_CD reported is not of 'Flat Amount' type.	TLX01580	QTY cannot be zero
74	TLX01590	Cannot report Override rate	Validate that OVERRIDE_RATE is not reported along with an Amount type TRC.	TLX01590	Cannot report Override Rate
75	TLX01600	Invalid Time Reporter	The reported time is earlier than the Time and Labor enrollment date.	TLX01600	Invalid Time Reporter
76	TLX01630	Comp Rate Code Validation	The Comp Rate Code reported has a rate type equal to points and is not valid.	TLX01630	Invalid Comp Rate Code
77	TLX01640	Reported Rules only TRC	The reported TRC is not valid for time entry. The TRC used is valid for Rules generated time only.	TLX01640	Invalid TRC
78	TLX01650	TRC not valid for Punch Time	The TRC reported is not a hours type TRC. Only a hours type TRC can be used to report punch time.	TLX01650	TRC not valid for Punch Time
79	TLX01660	TRC Associated with comp/leave	The TRC reported is associated with compensation / leave indicator and is invalid to use for reporting punch time.	TLX01660	TRC associated with comp/leave
80	TLX01670	HR BU not mapped to a GL BU	The reported HR Business unit is not mapped to a GL Business Unit.	TLX01670	HR BU not mapped to GL BU
91	TLX01690	Reported Absence TRC	Warns the user that absence event information can only be reported in Absence module.	TLX01690	The reported TRC is not valid for time entry. The TRC used is valid for Absence generated time only.
82	TLX01700	Full Absence & Reported Time	When Full day absence exists and there is a reported time.	TLX01700	Time is reported for Full day Absence.?
83	TLX01710	Partial Absence & Punch Time	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.	TLX01710	Partial absence reported and also Reported Partial Punch Time.
84	TLX01770	Reported time in prior period	Validate if time reporter has reported time in prior period	TLX01770	Reported time in prior period
85	TLX01780	Reported time in future period	Validate if time reporter has reported time in future period	TLX01780	Reported time in future period
86	TLX01790	Reported time in prior year	Validate if time reporter has reported time in prior year.	TLX01790	Reported time in prior year