HDR: CLIQUE_ID Not Populated When Loading Editable Terminology Using OVERWRITE Option In Control File (Doc ID 2178090.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Healthcare Data Repository - Version 7.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 7.0.1.6 version, HTB/HDR Generic Issues

ACTUAL BEHAVIOR
---------------
When the ETS Loader and Importer are used with the OVERWRITE property set to TRUE to update an Editable terminology the HCT_ET_CONCEPTS.CLIQUE_ID is set to NULL for all rows in the Coding Scheme Version.

This causes all processing that access any code from that version to return an error. The error is caused by the equivalence check, which performs a null comparison.

EXPECTED BEHAVIOR
-----------------------
Customer is expected HCT_ET_CONCEPTS.CLIQUE_ID to be updated appropriately.

The work-around for this is to fill in the missing CLIQUE_ID by running the ETS Maintenance program on the active tables.

STEPS:

-----------

1. Create editable coding scheme

2. Create control file (and additional load files)

3. Execute the loader - success

4. Execute the importer job - success

5. Checking the concepts:

- for example:

 

Cause

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