LISTED CASE DISPLAYED AS UNLISTED IN THE CTPR MAIN LINE LISTING REPORT (Doc ID 1067490.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

In the CTPR Periodic report, the Main Listing and the Line Listing Tabulation may incorrectly classify a listed case as unlisted as a result of evaluating deleted rows in the database.

Steps to Repeat:
1. Create a Not Blinded study with 2 company products.
2. Create a Not Blinded study case using the study created in step 1 and do not select the study drug.
3. Go to product tab, right click on the already added product and select "add a new study product" to add new
study.
4. Save the case without selecting the study drug for both products and go to event tab.
5. Go to event assessment tab and select the causality as related and listedness as "Listed" for the first product.
No assessments are made for the second product.
6. Save the case, go to product tab and delete the second study product.
7. Lock the case.
8. Create a simple CTPR report that includes the case created in step 2 and ensure that the "Include line listing tabulation" checkbox under Summary tabulation tab is checked.
9. Run the report and observe that the above created case is marked as "Unlisted" in the main line listing as well
as the line listing tabulation section of the periodic report.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.