Case_Event_Detail Record Is Not Deleted If Product Is Changed From Suspect To Concomitant (Doc ID 2847217.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The Events-->Product Event Details screen shows the Product Event Matrix for suspect products.

If a suspect product gets modified to a 'Concomitant' or Treatment' product, the product no longer appears on the Events >Product - Event Details screen as expected,  however the record within the CASE_EVENT_DETAIL table still exists and is not updated to reflect it has been deleted.

Steps:

• Create case with two 'Suspect' Productsie.
  Product #1
  Product #2

Under Events> Product - Events Details Tab
Both products are reflected. (this is expected behavior)

When executing the following for example:

 Two records will be returned with DELETED column (null)

• Change Product #2 from 'Suspect' to 'Concomitant' and save the case.

Events> Product - Events Details Tab will only reflect Product #1 as expected.

However when executing the above query again, two records are still returned with the DELETED column remaining (null).
It is expected that the record for Product #2 will now have a DELETED date populated to reflect the change.

Cause

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