COA Validator Troubleshooting

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