Refer to the Uploading section for more information on how to upload the Update action.
To carry out an Update to the existing Transaction Controls, More4apps recommend downloading the Project and/or Tasks first to have all the existing Transaction Controls downloaded to the sheet.
To update a Transaction Control at the Project and Task levels, the ‘Proj TC Upload Action’ and ‘Task TC Upload Action’ must have the ‘Update’ action. The 'Proj TC Trans ID’ and 'Task TC Trans ID’ must be populated.
You may NOT update Transaction Controls if the ID cell is empty. This value is the key to the record. The Integrator considers an empty ID cell to mean that this is a new record.
Once the necessary data entry changes are made to the Transaction Controls section(s), upload the changes to Oracle.
The ‘Accepted’ status for ‘Project Transaction Controls Status’ and/or 'Task Transaction Controls Status’ is returned to the sheet if all the updates for the Transaction Controls are valid and uploaded successfully to Oracle.
