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.
On : 188.8.131.52 version, HTB/HDR Generic Issues
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.
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.
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:
select CONCEPT_CODE, CLIQUE_ID from hct.HCT_ET_CONCEPTS order by CREATION_DATE desc;
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