HDR: CLIQUE_ID Not Populated When Loading Editable Terminology Using OVERWRITE Option In Control File
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 : 18.104.22.168 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:
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