Please become familiar with the current Integrator limitations. These will be resolved over time as Oracle improves the underlying web services and we add additional functionality to this product. Please refer to the Uploading section for more information on how to upload the Create action.
Task Transaction Controls
To create a Task level Transaction Controls, the ‘Task TC Upload Action’ column value must be ‘Create’.
Enter the Task level Transaction Control details manually in the sheet or use the Data Form to enter details:
Task level Transaction Controls must be positioned on the same row or below the row containing the Task Number. It is not necessary to duplicate the Task Number on every row where there are multiple Transaction Controls for a single Task. More than one Transaction Control can be entered against a task. See the image below where Task 100.1 has 3 new transaction control entries in the worksheet.
Once the Transaction Controls are uploaded, the ‘Task TC Trans ID’ will be returned to the sheet. The ‘Task TC Trans ID’ is a unique number created for the Transaction Control and it is required to carry out the Update and Delete Actions.
The ‘Accepted’ status for ‘Task Transaction Controls Status’ is returned to the sheet if all the Transaction Controls are valid and uploaded successfully to Oracle.
Project Transaction Controls
To create a Project level Transaction Controls, the ‘Project TC Upload Action’ column value must be ‘Create’.
Enter the Project level Transaction Control details manually to the sheet or use the Data Form to enter details:
Project level Transaction Controls must be positioned on the same row or below the row containing the Project Number. It is not necessary to duplicate the Project Number on every row where there are multiple Transaction Controls for a single Project. More than one Transaction Control can be entered against a Project. See the image below where Project ‘WTTC001’ has 3 new Transaction Control entries in the worksheet.
Once the Transaction Controls are uploaded, the ‘Proj TC Trans ID’ will be returned to the sheet. The ‘Proj TC Trans ID’ is a unique number created for the Transaction Control and it is required to carry out the Update and Delete Actions.
The ‘Accepted’ status for ‘Project Transaction Controls Status’ is returned to the sheet if all the Transaction Controls are valid and uploaded successfully to Oracle.
