Appendix: Exceptions and Validations

This appendix lists Time and Labor exceptions and validations.

Click to jump to parent topicUnderstanding 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

TLX00001

Invalid Comp Time TRC/Balance

Verify that:

The Reported Comp Time TRC is valid

The Comp Time balance is valid as per the Comp Time Plan.

Keep the Exception TLX00001 at 'high' severity. A low or medium severity exception can create payable time. However, if the time reporter is reporting a comp TRC that is not in his comp plan, this is still an exception. Although the system can create the payable time, it will not be able to update the comp time balance.

TLX00001

Invalid Comp Time TRC/Balance

2

TLX00010

Invalid Leave Time Taken

Verify that the NA Earnings Code associated with the reported TRC is mapped to a Plan Type in the EARNINGS_ACCRL table.

TLX00010

Invalid Leave Time Taken

3

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

4

TLX00040

Valid Taskgroup

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

TLX00040

Invalid Taskgroup

5

TLX00050

Active Taskgroup

Verify that the Taskgroup is 'Active' as of the date reported.

TLX00050

Inactive Taskgroup

6

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

7

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

8

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

9

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

10

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

11

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

12

TLX00130

BUSINESS_UNIT_PC

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

TLX00130

Invalid Value for Task Templt

13

TLX00131

BUSINESS_UNIT_PC

Verify that the BUSINESS_UNIT_PC reported exists in the TL_BUS_CA_PC_VW when TASK_PROFILE_ID is not reported, and the COMMIT_ACCTG_FLG on task template is 'Y' and PS/Projects is installed.

TLX00131

Invalid PC Business Unit

14

TLX00132

BUSINESS_UNIT_PC

Verify that the BUSINESS_UNIT_PC reported exists in BUS_UNIT_PC_VW when TASK_PROFILE_ID is not reported, and the COMMIT_ACCTG_FLG on task template is 'N' and PS/Projects is installed.

TLX00132

Invalid PC Business Unit

15

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

16

TLX00150

COMPANY

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

TLX00150

Invalid Company

17

TLX00160

LOCATION

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

TLX00160

Invalid Location

18

TLX00170

JOBCODE

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

TLX00170

Invalid Jobcode

19

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

20

TLX00190

CUSTOMER

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

TLX00190

Invalid Customer

21

TLX00200

DEPTID

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

TLX00200

Invalid Department

22

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

23

TLX00220

TASK

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

TLX00220

Invalid Task

24

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

25

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

26

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

27

TLX00240

RESOURCE_TYPE

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

TLX00240

Invalid Value for Task Templt

28

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

29

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

30

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

31

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

32

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

33

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

34

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

35

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

36

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

37

TLX00300

ACTIVITY_ID

Verify that ACTIVITY_ID is reported when TASK_PROFILE_ID is not reported, PS/Projects is not installed and PS/EPM is installed.

TLX00300

Required Value for Task Templt

38

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

39

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

40

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

41

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

42

TLX00350

POSITION_NBR

Verify that POSITION_NBR is not reported when POSITION_MGMT on INSTALLATION table is 'N'.

TLX00350

Invalid Value for Task Templt

43

TLX00360

PROJECT_ID

Verify that PROJECT_ID is reported when TASK_PROFILE_ID is not reported, both PS/Projects and PS/EPM are installed, COMMIT_ACCTG_FLG is 'N', and both BUSINESS_UNIT_PC and ACTIVITY are required fields on the task template.

TLX00360

Required Value for Task Templt

44

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

45

TLX00362

PROJECT_ID

Verify that PROJECT_ID is reported when TASK_PROFILE_ID is not reported, PS/Projects is installed, PS/EPM is not installed, COMMIT_ACCTG_FLG is 'N' and ACTIVITY is a required field on the task template.

TLX00362

Required Value for Task Templt

46

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

47

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

48

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

49

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

50

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

51

TLX00420

Valid TRC

Verify that the reported TRC exists in the TL_TRC_TBL.

TLX00420

Invalid TRC

52

TLX00430

Active TRC

Verify that the TRC is 'Active' as of the date reported.

TLX00430

Inactive TRC

53

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

54

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

55

TLX00480

COMP_RATECD

Verify that the COMP_RATECD reported is neither of 'Percent' type nor of 'Points' type.

TLX00480

Invalid Comp Rate Code Type

56

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

57

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

58

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

59

TLX00520

COMP_RATECD & TRC Reported

Verify that a TRC is reported when a COMP_RATECD is reported.

TLX00520

TRC needed for Comp Rate Code

60

TLX00530

COMP_RATECD

Verify that if a COMP_RATECD is reported, it is a valid COMP_RATECD.

TLX00530

Invalid Comp Rate Code

61

TLX00540

COMP_RATECD

Verify that if a COMP_RATECD is reported, it is 'Active' as of the date reported.

TLX00540

Inactive Comp Rate Code

62

TLX00560

BILLABLE_IND

Verify that BILLABLE_IND reported in Elapsed Time has the value of either 'Y' or 'N'.

TLX00560

Invalid Billable Indicator

63

TLX00570

COUNTRY

Verify that the COUNTRY reported in Elapsed Time is in the COUNTRY_TBL.

TLX00570

Invalid Country

64

TLX00590

CURRENCY_CD

Verify that the CURRENCY_CD reported in Elapsed Time is in the CURRENCY_CD_TBL.

TLX00590

Invalid Currency Code

65

TLX00600

LOCALITY

Verify that the LOCALITY reported in Elapsed Time is in the LOCAL_TAX_TBL.

TLX00600

Invalid Locality

66

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

67

TLX00640

RULE_ELEMENT_1

Verify that the RULE_ELEMENT_1 reported is in the TL_RULE_ELEMENT1 table.

TLX00640

Invalid Rule Element 1

68

TLX00650

RULE_ELEMENT_2

Verify that the RULE_ELEMENT_2 reported is in the TL_RULE_ELEMENT2 table.

TLX00650

Invalid Rule Element 2

69

TLX00660

RULE_ELEMENT_3

Verify that the RULE_ELEMENT_3 reported is in the TL_RULE_ELEMENT3 table.

TLX00660

Invalid Rule Element 3

70

TLX00670

RULE_ELEMENT_4

Verify that the RULE_ELEMENT_4 reported is in the TL_RULE_ELEMENT4 table.

TLX00670

Invalid Rule Element 4

71

TLX00680

RULE_ELEMENT_5

Verify that the RULE_ELEMENT_5 reported is in the TL_RULE_ELEMENT5 table.

TLX00680

Invalid Rule Element 5

72

TLX00740

STATE

Verify that the STATE reported is in the STATE_NAMES_TBL.

TLX00740

Invalid State

73

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

74

TLX00840

USER_FIELD_1

Validate that the USER_FIELD_1 reported exists on the TL_USER_FIELD_1 table.

TLX00840

Invalid User Field 1

75

TLX00850

USER_FIELD_2

Validate that the USER_FIELD_2 reported exists on the TL_USER_FIELD_2 table.

TLX00850

Invalid User Field 2

76

TLX00860

USER_FIELD_3

Validate that the USER_FIELD_3 reported exists on the TL_USER_FIELD_3 table.

TLX00860

Invalid User Field 3

77

TLX00870

USER_FIELD_4

Validate that the USER_FIELD_4 reported exists on the TL_USER_FIELD_4 table.

TLX00870

Invalid User Field 4

78

TLX00880

USER_FIELD_5

Validate that the USER_FIELD_5 reported exists on the TL_USER_FIELD_5 table.

TLX00880

Invalid User Field 5

79

TLX01540

More than 24 hours reported

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

TLX01540

More than 24 hours reported

80

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

81

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

82

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

83

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

84

TLX01590

Cannot report Override rate

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

TLX01590

Cannot report Override Rate

85

TLX01600

Invalid Time Reporter

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

TLX01600

Invalid Time Reporter

86

TLX01620

PC BU, Proj Rptd/Other Flds Re

Validate that PC Business Unit, Project ID and Activity are required in combination if any are reported and Project Costing is installed.

TLX01620

PC BU, Proj Rptd/Other Flds Re

87

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

88

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

89

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

90

TLX01660

TRC Assoc with comp/leave

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

TLX01660

TRC assoc with comp/leave

91

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

92

TLX01680

Project not valid with Combo Cd

Project ID reported is not valid with the reported combo code.

TLX01680

Project is not valid with Comb

93

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.

94

TLX01700

Full Absence & Reported Time

When Full day absence exists and there is a reported time.

TLX01700

Time is reported for Full day Absence.?

95

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.

96

TLX01770

Reported time in prior period

Validate if time reporter has reported time in prior period

TLX01770

Reported time in prior period

97

TLX01780

Reported time in future period

Validate if time reporter has reported time in future period

TLX01780

Reported time in future period

98

TLX01790

Reported time in prior year

Validate if time reporter has reported time in prior year.

TLX01790

Reported time in prior year

Click to jump to parent topic Timesheets and Online Validations

Online validations occur when you report time using Timesheets, either Elapsed or Punch, and click the Save for Later button or the Submit button. Validation occurs as of the Begin Date of the time period that is being viewed (day, week, or time period). These validations depend on the settings in the Validations Options group box on the T/L Installation page.

See Validation Options.

This section discusses these validations on the Weekly Elapsed Timesheet:

Comp Rate Code Validations

The validations for comp rate codes are:

See Pages Used to Define and Map Time Reporting Codes.

TRC Minimum Quantity and Maximum Quantity Validations

If the quantity reported is not between the minimum and maximum defined on the Time Reporting Codes - Definition page, an error message is generated.

Comp Time Validations

The validations for comp time are:

Leave Time Validations

The validations for leave time are:

Additional Edits

Additional validation edits are:

Click to jump to parent topicWeekly Punch Time Reporting Validations

These types of punch time reporting validations are discussed in this section:

Prior Period Access

The prior period access validations are:

Mid-Period Data Changes

If effective dated changes exist on the Maintain Time Reporter Data page that fall within the current week, generate this error message: New punch entries with a date value on or after "x" are not allowed for this session.

Minimal Data Requirements

Validate that punch time is entered; if not, generate an error message indicating that time is required.

Validate that punch date is entered; if not, generate an error message indicating that date is required.

Click to jump to parent topicTime and Task Reporting Template Validations

These validations apply to both elapsed and punch reported time: