Correcting Errors and Reloading
If you have a Rejected status in any of the status columns, you need to read the message in the ‘Upload Error’ column and investigate the data. The error messages relate to data on the same row.
If you have duplicated data on your sheet, i.e. the combination of Task, Period and Resource is not unique for the budget being uploaded; you will be offered a choice. Accept this as intended and accumulate the values before uploading, or error the budget. If you choose to error the budget, all the duplications will be shown in yellow, in order to help you find the problem. If you accept the duplications, then yellow will not be used on the duplicated cells.
‘Line Ok’ is used to show that the line passed the first level of validation and has been loaded into temporary tables, awaiting the step to create the draft budget. In the case of period phased budgets, the status serves for all the values on the line.
‘Upload Ok’ is used to show the status of the ‘Create Draft Budget’ step. If you baseline the budget it represents the status of the ‘baseline budget’ step, presuming you got that far. This column is only populated for the first row of the project budget.
If this column shows an ‘Ok’ then you cannot upload the budget. The upload will ignore this budget. If you do want to upload the budget again (you may have made changes) then simply delete the ‘Ok’.
The above constraint only applies to the ‘Upload OK’ column. You may safely ignore anything in the ‘Line Ok’ column. This column will be cleared by the program as the upload commences.
Correcting Rejected Data
To correct the information either key directly into the worksheet or open the relevant data entry form.
Once the data has been corrected you can choose to either upload one row, selected rows or the entire worksheet.
Budgets that already have an upload Status of ‘Ok’ will not be processed again.
Continuing the previous example, after correcting the data and re-running the upload process, all records are successfully transferred into Oracle Projects.
Refer to section: Status and Message Columns