Trip Report Template Deletion In Siebel CTMS Caused Data Loss In Production

(Doc ID 2151546.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Trip Reports for Clinical Trial Management System - Version 8.1 [21039] and later
Information in this document applies to any platform.


On : 8.1 [21039] version, Client Functionality

Deletion of a trip report deletes all associated activities

Customer asked if this was expected

The issue can be reproduced at will with the following steps:
1. Navigate to Administration - Data | Activity Templates and create a template of type "Clinical Trip Report".
2. Create several activity template detail records for this template.
3. Navigate to Site Management. Drill down on a site #.
4. Navigate to the tab "Site Visits". Create a new visit, and drill down on the visit start date.
5. Associate the template created above to this trip report.

>> Here activities were created under Site Management. Drill down on a site #. > Activities tab and Current Trip Follow-up Items

6. Now go back and delete the activity template under Administration - Data | Activity Templates
7. navigate back to the trip report you just created, all the child activities have been deleted

>> Here, activities were deleted from Activities and Current Trip Follow-up Items

The issue has the following business impact:
Due to this issue, users cannot see activities after the deletion


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms