COA Validator Troubleshooting
- Marissa Kitz (Unlicensed)
Validation Errors
The following is a full set of warnings/error messages that will be returned by the COA Validation Web service if the validation fails on one or more COA segments. These are the defined error/warning messages, they are always prefixed with “Ennn” or “Wnnn”.
Input | Validation | Error/Warning Message |
Company | Input is blank | E001 – Company is required |
Company | Input is not a valid value | E002 – Company does not exist |
Transaction Date | Tran date is blank then Tran date=current date | W004 – Current date assumed |
Transaction Date | Transaction date format is not mm/dd/yyyy | E005 – Invalid transaction date format |
Transaction Date | Transaction date is not a valid date (e.g. 02/29/2015) | E006 – Invalid transaction date |
Cost Center | Input is blank and Grant is blank | E001 – Cost Center is required |
Cost Center | Input is not a valid value | E002 – Cost Center does not exist |
Cost Center | Cost Center status <> active | E003 - Cost Center not active |
Cost Center | Cost Center can be valid for one or more companies. Company value not in List of Cost Center companies | E006 – Cost Center does not exist for the ‘Company’ |
Program | Input is blank and Grant is blank | E001 – Program is required |
Program | Input is not a valid value | E002 – Program does not exist |
Program | Program status <> active | E003 – Program not active |
Yale Designated | Input is blank and Gift is blank and Grant is blank | E010 – One of Grant, Gift or Yale Designated is required |
Yale Designated | Input is not a valid value | E002 – Yale Designated does not exist |
Yale Designated | Yale Designated status <> active | E003 – Yale Designated not active |
Yale Designated | Yale Designated <> blank and Gift <> blank | E009 – Gift and Yale Designated are not allowed together |
Gift | Input is blank and YD is blank and Grant is blank | E010 – One of Grant, Gift or Yale Designated is required |
Gift | Input is not a valid value | E002 – Gift does not exist |
Gift | Inactive =’yes’ | E003 – Gift not active |
Gift | Inactive = ‘no’ and Gift status <> ‘approved’ | E004 – Gift not approved |
Gift | Yale Designated <> blank and Gift <> blank | E009 – Gift and Yale Designated are not allowed together |
Grant | Input is blank and YD is blank and Gift is blank | E010 – One of Grant, Gift or Yale Designated is required |
Grant | Input is not a valid value | E002 – Grant does not exist |
Grant | Grant status <> active | E003 – Grant not active |
Grant | Grant status = active and Tran date not between Award Line Start Date and Award Line End Date | E007 – Transaction date does not fall between Award Line Start and End dates |
Grant | Grant status = active and Award Line Lifecycle status not in (active, at risk) | E008 – Award Line Lifecycle status not active |
Revenue Category | Input is blank and Spend Category is blank and Ledger Account is blank | E012 – One of LA, Revenue category, Spend category is required |
Revenue Category | Input is not a valid value | E002 – Revenue Category does not exist |
Revenue Category | Revenue Category status<>active | E003 – Revenue category not active |
Revenue Category | If Revenue category <> blank and Spend category <> blank | E011 – Only one of Revenue category, Spend category is allowed |
Spend Category | Input is blank and revenue Category is blank and Ledger Account is blank | E012 – One of LA, Revenue category, Spend category is required |
Spend Category | Input is not a valid value | E002 – Spend Category does not exist |
Spend Category | Spend Category status <> active | E003 – Spend category not active |
Spend Category | If Revenue category <> blank and Spend category <> blank | E011 – Only one of Revenue category, Spend category is allowed |
Ledger Account | Input is blank and Spend Category is blank and Revenue Category is blank | E012 – One of LA, Revenue category, Spend category is required |
Ledger Account | Input is not a valid value | E002 – Ledger Account does not exist |
Ledger Account | Ledger Account status = retired | E003 – Ledger Account not active |
Project | Input is blank and Grant is blank and Cost Center is blank | E001 – Project is required |
Project | Input is not a valid value | E002 – Project does not exist |
Project | Inactive =’yes’ | E003 – Project not active |
Project | Inactive =’no ’and Tran date not between Project Start Date and Project End Date | E007 – Transaction date does not fall between Project Start and End dates |
Assignee | Input is not a valid value | E002 – Assignee does not exist |
Assignee | Assignee status= inactive | E003 – Assignee not active |
Location | Input is not a valid value | E002 – Location does not exist |
Location | Location status <> active | E003 – Location not active |
Related articles