Remove duplicate MER

Owned by Noreen Dertinger
Last updated: Apr 26, 2024
1 min read

Solution for bug 340730 Duplicate MER was entered.
See subtask 341656 Remove Duplicate MER for the exact queries that were run.

 

  1. Identify and backup the applicant records.

    select * from UA006_MEDICAL_EXAMINATION where FAMILY_NAME_NM = 'familyname' and upper(FIRST_NAME_NM) like upper('firstname%');

  2. Select specific columns.

    select MEDICAL_EXAMINATION_ID, MEDICAL_EXAMINATION_DTE, LICENCE_NUM, APPLICANT_PERSON_ID, FIRST_NAME_NM, FAMILY_NAME_NM, DATE_BIRTH_DTE, STAMP_NUMBER_TXT, DATE_CREATED_DTE, DATE_DELETED_DTE, DATE_LAST_UPDATE_DTE, DATE_EMER_SUBMITTED_DTE from UA006_MEDICAL_EXAMINATION where FAMILY_NAME_NM = 'familyname' and upper(FIRST_NAME_NM) like upper('firstnsme%');

  3. Remove the duplicate record by setting the DATE_DELETED_DTE to current date:

    update UA006_MEDICAL_EXAMINATION set DATE_DELETED_DTE = SYSDATE where MEDICAL_EXAMINATION_ID = medical_examination_id and LICENCE_NUM = licence_num;

  4. Commit the change to the database:

  5. Viewed the change:

  6. Check for related records in UA016_ACTIVITY_CLUSTER:
    (there were none for the bug I worked on. If there are, they should also be “removed”).

  7. Check for related records in UA033_APPLICANT_DOCUMENT:
    (there were none for the bug I worked on. If there are, they should also be “removed”).