Step-4: Run a qery to get duplicate activities.
Open an SQL Console and paste the following query: SELECT ACTIVITY_ID FROM USR_BOKFEKW1UQIR49ZB0UMWNTMFE.TAE_ACTIVITY WHERE TURNAROUND_ID =
'6d32f860-c786-4fc4-9053-8dff9568ea7a' AND DELETED = 0 GROUP BY ACTIVITY_ID HAVING COUNT(ACTIVITY_ID) > 1;
Replace the text in red with the copied TURNAROUND_ID.
Click run and you should see the activities that are duplicated for that Turnaround.
Step-5: Delete/Change them one-by-one.
Open the Table TAE_ACTIVITY and Open Data and paste a selected activity id in the Search, it should display all the duplicated copies.
To Delete: To delete an activity set the deleted to 1 by clicking once in the cell to enter edit mode and set it to 1 and hit save.
To Keep Both Activities: Again enter edit mode this time on the ACTIVITY_ID column and change a number the id ranges from 1-9 and a-e. Hit save to save the new activity id.
Step-6: Run the same query to verify all duplicates have been deleted/changed.
From the SQL Console execute the same query and verify that this time there are 0 rows in the output.