Deleting Unused Metadata Qualifiers From ODB

(Doc ID 2330310.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Healthcare Foundation - Version 7.1.2 to 7.1.2 [Release 7.1]
Information in this document applies to any platform.

Goal

To delete unused metadata qualifiers that were inserted by QC metadata loader.

This might be desired in case when records populated by QC Metadata loader were manually deleted from W_EHA_RSLT_SPEC_QLFR, and W_EHA_RSLT_FILE_SPEC_QLFR tables. The attached procedure will remove metadata qualifiers associated with these removed records.

Solution

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