Processing Error Messages
The following error messages may be displayed on the screen when you run this preprocessor.
These errors cause processing to terminate.
Message | Description |
---|---|
Each Deduction line in the input file should contain 10 fields. Line <Line Number> of your input file contains <Number of Fields> fields. Abort processing? | Comma Separated Values (.CSV) input file Deduction record (first character of record = D) contains greater than or less than 10 fields. |
Each Contribution line in the input file should contain 8 fields. Line <Line Number> of your input file contains <Number of Fields> fields. | Comma Separated Values (.CSV) input file Contribution record (first character of record = C) contains greater than or less than 8 fields. |
Each Leave line in the input file should contain 5 fields. Line <Line Number> of your input file contains <Number of Fields> fields. | Comma Separated Values (.CSV) input file Leave record (first character of record = L) contains greater than or less than 5 fields. |
Record "D" of the input file should be 79 characters in length. Line <Line Number> of your input file contains <Line Length> characters. | Fixed-length input file Deduction record (first character of record = D) contains greater than or less than 79 characters. |
Record "C" of the input file should be 67 characters in length. Line <Line Number> of your input file contains <Line Length> characters. | Fixed-length input file Contribution record (first character of record = C) contains greater than or less than 67 characters. |
Record "L" of the input file should be 33 characters in length. Line <Line Number> of your input file contains <Line Length> characters. | Fixed-length input file Leave record (first character of record = L) contains greater than or less than 33 characters. |
The record code (Position 1) must be "D", "C" or "L". Line <Line Number> of your input file contains <Position 1 Character>. | Fixed-length input file record does not contain a D, C, or L as the first character. |
Report Error Messages
The following error messages may appear on the Error Report when you run this preprocessor. If an error is encountered in the input file, the record causing the error is rejected.
Message | Description |
---|---|
Value truncated. | Input Field Length > Maximum Field Length and Truncate Values is set to Always truncate (A) on screen. |
Value too long for field. | If Input Field Length > Maximum Field Length and Truncate Values is set to Never truncate (N) on screen. |
Report Warning Messages
The following warning messages may appear on the Error Report when you run this preprocessor. If a warning is encountered in the input file, the record causing the warning is still processed.
Message | Description |
---|---|
<Field name> '<field value>' on input file line <line number> is too long. | Input Field Length > Maximum Field Length and Truncate Values is set to Warn before truncation (W) on screen. |
Invalid Deduction Start Date. | DED_START_DT value read from Input File is not a valid date. |
Invalid Deduction End Date. | DED_END_DT value read from Input File is not a valid date. |
Invalid Ded End Coverage Date. | END_CVG_DT value read from Input File is not a valid date. |
Rate is out of range $-99,999,999.99 to $99,999,999.99. | DED_RT_AMT value from Input File is a valid number and DED_RT_AMT value from Input File < -99999999.99 OR > 99999999.99. |
Rate is not numeric. | DED_RT_AMT value from Input File is not a valid number. |
Annual Ceiling is out of range $-99,999,999.99 to $99,999,999.99. | DED_ANN_CEIL_AMT value from Input File is a valid number and DED_ANN_CEIL_AMT value from Input File < -99999999.99 OR > 99999999.99. |
Annual Ceiling is not numeric. | DED_ANN_CEIL_AMT value from Input File is not a valid number. |
A positive Priority Number is required. | DED_PRIORITY_NO value from Input File is a valid number and DED_PRIORITY_NO value from Input File <= 0. |
Priority Number is not numeric. | DED_PRIORITY_NO value from Input File is not a valid number. |
Invalid Contribution Start Date. | CNTRB_START_DT value read from Input File is not a valid date. |
Invalid Contribution End Date. | CNTRB_END_DT value read from Input File is not a valid date. |
Rate is out of range $0.0000 to $99,999,999.99. | CNTRB_RT_AMT value from Input File is a valid number and CNTRB_RT_AMT value from Input File < 0 OR > 99999999.99. |
Rate is not numeric. | CNTRB_RT_AMT value from Input File is not a valid number. |
Annual Ceiling is out of range $0.00 to $99,999,999.99. | CNTRB_ANN_CEIL_AMT value from Input File is a valid number and CNTRB_ANN_CEIL_AMT value from Input File < 0 OR > 99999999.99. |
Annual Ceiling is not numeric. | CNTRB_ANN_CEIL_AMT value from Input File is not a valid number. |
Invalid Leave Hire Date. | LV_HIRE_DT value read from Input File is not a valid date. |
Duplicate Deduction for Employee. | EMPL_ID and DED_CD in one record in table Z_AOPUTLDL_INP_D are the same as EMPL_ID and DED_CD in any other record. |
Duplicate Deduction Priority for Employee. | PR_SETTINGS.DED_PRIORITY_FL = Y and EMPL_ID and DED_PRIORITY_NO fields in one record in table Z_AOPUTLDL_INP_D are the same as EMPL_ID and DED_PRIORITY_NO in any other record and the DED_PRIORITY_NO is not equal to 99. |
Deduction Priority for Employee already exists. | PR_SETTINGS.DED_PRIORITY_FL = Y and the DED_PRIORITY_NO is not equal to 99 and EMPL_ID and DED_PRIORITY_NO fields in one record in table Z_AOPUTLDL_INP_D are the same as EMPL_ID and DED_PRIORITY_NO in another record in which the DED_CD fields differs from the DED_CD in the first record. |
Duplicate Contribution for Employee. | EMPL_ID and CNTRB_DED_CD in one record in table Z_AOPUTLDL_INP_C are the same as EMPL_ID and CNTRB_DED_CD in any other record. |
Duplicate Leave for Employee. | EMPL_ID and LV_CD in one record in table Z_AOPUTLDL_INP_L are the same as EMPL_ID and LV_CD in any other record. |
Employee Id is a required field. | EMPL_ID is empty in the Z_AOPUTLDL_INP_D input table. |
Deduction Code is a required field. | DED_CD is empty in the Z_AOPUTLDL_INP_D input table. |
Deduction Method is a required field. | S_DED_MTHD_CD is empty in the Z_AOPUTLDL_INP_D input table. |
Employee Id is a required field. | EMPL_ID is empty in the Z_AOPUTLDL_INP_C input table. |
Contribution Code is a required field. | CNTRB_DED_CD is empty in the Z_AOPUTLDL_INP_C input table. |
Contribution Rate/Amount is a required field. | CNTRB_RT_AMT is empty in the Z_AOPUTLDL_INP_C input table. |
Contribution Method is a required field. | S_CNTRB_MTHD_CD is empty in the Z_AOPUTLDL_INP_C input table. |
Employee Id is a required field. | EMPL_ID is empty in the Z_AOPUTLDL_INP_L input table. |
Leave Code is a required field. | LV_CD is empty in the Z_AOPUTLDL_INP_L input table. |
Leave Type is a required field. | LV_TYPE_CD is empty in the Z_AOPUTLDL_INP_L input table. |
Invalid Deduction Method. | S_DED_MTHD_CD in the Z_AOPUTLDL_INP_D table is not one of the following: FIXAMT, ADDGRS, GRSHRF, GRSHRP, NO DED, PCTANN, PCTGRS, PCTREG, REGHRF, REGHRP, PCTCOD, GHRSPD, PCTDPI. |
Invalid Contribution Method. | S_CNTRB_MTHD_CD in the Z_AOPUTLDL_INP_C table is not one of the following:
FIXAMT, GRSHRS, PCTDED, NO DED, PCTANN, PCTGRS, PCTREG, REGHRS, PCTDED, REGHRF, REHRP, GRSHRF, GRSHRP. |
Invalid Date Range. | DED_START_ DT is Not Null and DED_END_DT is Not Null and DED_END_DT < DED_START_DT in table Z_AOPUTLDL_INP_D. |
Invalid Date Range. | CNTRB_START_ DT is Not Null and CNTRB _END_DT is Not Null and CNTRB _END_DT < CNTRB _START_DT in table Z_AOPUTLDL_INP_C. |
Out of Range 0.00 to 100. | The first three characters of the S_DED_MTHD_CD = PCT and (DED_RT_AMT < 0 or DED_RT_AMT > 100) in table Z_AOPUTLDL_INP_D. |
Out of Range 0.00 to 100. | The first three characters of the S_CNTRB_MTHD_CD = PCT and (CNTRB_RT_AMT < 0 or CNTRB_RT_AMT > 100) in table Z_AOPUTLDL_INP_C. |
Too many decimal places. | S_DED_MTHD_CD is either FIXAMT or ADDGRS and DED_RT_AMT is not equal to the rounded value of DED_RT_AMT (2 decimal places). |
Too many decimal places. | S_ CNTRB_MTHD_CD is either FIXAMT or ADDGRS and CNTRB_RT_AMT is not equal to the rounded value of CNTRB_RT_AMT (2 decimal places). |
Employee ID is invalid. | Value in Z_AOPUTLDL_INP_D.EMPL_ID does not exist in EMPL_ID field of EMPL table. |
Employee ID is invalid. | Value in Z_AOPUTLDL_INP_C.EMPL_ID does not exist in EMPL_ID field of EMPL table. |
Employee ID is invalid. | Value in Z_AOPUTLDL_INP_L.EMPL_ID does not exist in EMPL_ID field of EMPL table. |
Deduction code is not set up. | Not (Z_AOPUTLDL_INP_D.DED_FL = Y and Z_AOPUTLDL_INP_D.EMPL_ID = EMPL.EMPL_ID and EMPL.COMPANY_ID = DED_CD.COMPANY_ID and Z_AOPUTLDL_INP_D.DED_CD = DED_CD_CORP.DED_CD and DED_CD_CORP.DED_FL = Y and Z_AOPUTLDL_INP_D.DED_CD = DED_CD_CORP.DED_CD). |
Contribution Code is not set up. | Not (Z_AOPUTLDL_INP_C.CNTRB_FL = Y and Z_AOPUTLDL_INP_C.EMPL_ID = EMPL.EMPL_ID and EMPL.COMPANY_ID = DED_CD.COMPANY_ID And Z_AOPUTLDL_INP_C.CNTRB_DED_CD = DED_CD_CORP.DED_CD and DED_CD_CORP.CNTRB_FL = Y and Z_AOPUTLDL_INP_C.CNTRB_DED_CD = DED_CD_CORP.DED_CD). |
Leave Type/Leave Code combination is invalid. | Not (Z_AOPUTLDL_INP_L.LV_TYPE_CD = LV_TABLE.LV_TYPE_CD and Z_AOPUTLDL_INP_L.LV_CD = LV_TABLE.LV_CD and Z_AOPUTLDL_INP_L.LV_TYPE_CD Is Not Null and Z_AOPUTLDL_INP_L.LV_CD Is Not Null). |
Cannot replace leave code when leave type exists. | Z_AOPUTLDL_INP_L.EMPL_ID = EMPL_LV_ACCRL.EMPL_ID and Z_AOPUTLDL_INP_L.LV_TYPE_CD = EMPL_LV_ACCRL.LV_TYPE_CD. |
Deductions Cannot Be Processed – Not licensed for Payroll | Add-On license for Payroll (PR) is not found and RECORD_CD value read from input file = D. |
Contributions Cannot Be Processed – Not licensed for Payroll | Add-On license for Payroll (PR) is not found and RECORD_CD value read from input file = C. |
Union deductions cannot be assigned to individual employees. | The deduction code from the input file has a DED_CD_CORP.s_ded_type = UDED (Union Deduction). |
Arrears deduction not assigned to a deduction. | The deduction code from the input file has a DED_CD_CORP.s_ded_type = ARR (Arrears) and the deduction code from the input file is not assigned to another DED_CD as an Arrears Deduction (Input file Deduction Code is not equal to DED_CD_CORP.ded_arrears_cd). |
Method must be ADDGRS. | The deduction code from the input file has a DED_CD_CORP.s_ded_mthd_cd = ADDGRS and the compute method from the input file is not equal to ADDGRS. |
Method cannot be changed to ADDGRS. | The deduction code from the input file does not have a DED_CD_CORP.s_ded_mthd_cd = ADDGRS and the compute method from the input file is ADDGRS. |
Method cannot be changed to ADDGRS. | The deduction code from the input file has a DED_CD_CORP.s_ded_mthd_cd = PCTCOD and the deduction code from the input file does not have a DED_CD_CORP.s_ded_type = ADMFEE (Admin. Fee Court Orders). |
Parent Topic: Import Employee Leave And Deductions