CASE_MASTER.LAST_UPDATE_TIME Not Updated After MedDRA Recode Terms Were Updated In CASE_LAB_DATA (Doc ID 2856093.1)

Last updated on DECEMBER 04, 2023

Applies to:

Goal

After a MedDRA recode, the corresponding terms in the CASE_LAB_DATA table were updated. 
As expected, the user also observed corresponding AUDIT_LOG entries. 

However, the corresponding CASE_MASTER.LAST_UPDATE_TIME was not updated.

Is this expected behavior? What would explain what has been observed?


Specifically, it is believed that the following SQL join should not return any rows, but it does:

They do not match.

Only a few cases exhibit this behavior. And not all transactions are getting missed.
 

Solution

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