To update events, the ‘Header Upload Action’ column value must be ‘Update’. Refer to the Uploading section for more information on how to upload the Update action.
To carry out an Update to the existing events, More4apps recommend downloading them first on the sheet. Refer to the Download Events section for more information on how to download.
To update an event, the ‘Events Upload Action’ must have Update action if the values are to be updated or left blank if no processing of the data is required. The following columns are required on the sheet to Update an event:
● Event Number
● Business Unit
● Contract Number
● Contract Line
You cannot update the following columns:
● Business Unit
● Event Number
● Contract Number
● Contract Line
● Item Based Event Flag
● Application Source
● Event Source
For Item based events, the following columns cannot be updated in addition to the above columns:
● Event Type
● Description
Existing Events that do not have existing Project Numbers and Task Number against them can be updated to add them in. See example below:
If a contract line has more than one project association, you can update the project number/task number with another that belongs to the same contract line. See example below:
Once the necessary data entry changes are made, upload the changes to Oracle.
The ‘Accepted’ status is returned to the sheet if all the Updates for the sections are valid and uploaded successfully to Oracle.