My Oracle Support Banner

Discrepancies Deleted From The Database Tables (Not Longer Displayed In UI) (Doc ID 2486503.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.8.1 and later
Information in this document applies to any platform.

Symptoms

DMW 2.4.8.1

Discrepancies deleted from the database tables.

ISSUE
=======
Observed a pair of discrepancies deleted from the UI and from the database.

Queried the below tables to check if the discrepancies present in the DB tables but unable to find the missing discrepancies.
Found <NOTE:2433986.1> "What Does 'Soft-delete Discrepancy' Mean" that talks about discrepancies getting soft deleted. Why the discrepancies disappeared forever from the database when the documentation says discrepancies will be only soft deleted?

Discrepancy tables queried to find the above discrepancies.

dme_pub_disc_send_errors_v
dme_discrepancies_goto_v
dme_disc_history_v
dme_disc_actions_v
dme_discrepancies


Initialized the study Data Model Business Area. queried ba_schema.discrepancies_v. It did not return the discrepancies mentioned above.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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