During an upload, messages are displayed in a Processing form. The data is still validated and errors are handled as per the form validation. Any invalid rows will not be uploaded.
All worksheets will be created with a ‘Status’ and ‘Message’ column for each section.
Status
There is a ‘Status’ column for each section and this is used to record the progress of the record in each section. These are found at the beginning of the worksheet to enable the user to determine if any issues have been found. If an issue is found, double-click on the status to go to the appropriate section in the workbook.
The Status may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process where the status columns have been cleared or the record has been entered manually through the forms.
Validated
All the information for this record has successfully passed the spreadsheet validation with no errors (but has not been loaded into Oracle.
Accepted
All the information for this record has been successfully loaded into Oracle.
Error
All the information for this record has not been successfully loaded into Oracle
Message
There is a ‘Message’ column for each section and this is used to record any issues with the record for each of the section(s). The ‘Message’ column is held at the beginning of each section and will be ‘blank’ if no errors were found.
To navigate to the error message, double-click on the associated status with the error. This will take you to the error message held at the beginning of the appropriate section.
All error messages will have "API Error: " in the front of errors that are supplied by the Oracle API. Additionally, it will include the name of the API at the end of the error message.
Examples:
(ii)The following is an example of one API error message displayed when a funding record is uploaded with Create Baseline set to ‘Yes’. The project selected for the funding record is invalid for baseline creation, therefore fails with an error message:
API Error: You must enable the Baseline Funding Without Budget option for the project before you baseline the budget. (PROJECT=138530) (TASK=) (BUDGET_TYPE=) (SOURCE_NAME=) (START_DATE=)[pa_agreement_pub.create_baseline_budget]
(iii) In the following example the Agreement Status has errored.
If you have removed or renamed a compulsory column you will be informed.
