Status and Message Columns
Every worksheet will be created with a ‘Status’ and ‘Error’ column for each section.
The ‘Status’ is used to record the status for each record and section. The ‘Status’ may be:
|
Status
|
Status Explanation
|
|
Blank
|
Prior to running the validate/upload process.
|
|
Updated
|
All the information for this record has been updated into Oracle Projects.
|
|
Loaded
|
All the information for this record has been successfully created and loaded into Oracle Projects.
|
|
Error
|
All the information for this record has not been successfully loaded into Oracle Projects.
|
|
Deleted
|
All the information for this record has been deleted from Oracle Projects.
|
The ‘Error’ column is used to record any warning or error messages resulting from the Validate/Upload process e.g. ‘The Template does not have entry for Key Members’.
Note - AMG may come back with errors during the upload process which may not be detected during validation by the worksheet. In this case the entire project will NOT be uploaded, even if only one task is to blame.
In the following example, one project record was rejected with the message ‘Template does not have entry for Key Members’. All other records were successfully processed.
Refer to section: