SQL STATEMENT FOR LM_REPORTER_INSTITUTIONS IS USING WRONG DELETE NULL STATEMENT in upgrade script to Argus V6.0 (Doc ID 1296019.1)

Last updated on SEPTEMBER 26, 2011

Applies to:

Oracle Argus Safety - Version: 6.0 and later   [Release: 6.0 and later ]
Information in this document applies to any platform.

Symptoms


After running the upgrade scripts for LM_REPORTERS_INSTITUTIONS from Argus version 5.1 to 6.0, we have noticed that we are missing data.

In the upgrade script SQL, the cursor 'cur2' is used to retrieve records to populate table LM_REPORTER_INSTITUTION.

 Here is the SQL statement that has the issue:

CURSOR cur2
IS
SELECT a.reporter_id, b.inst_id
FROM lm_reporter a, lm_institution b
WHERE a.institution = b.institution and A.DELETED IS NOT NULL;


The SELECT statement only retrieves records for institutions in LM_REPORTER which have been deleted (A.DELETED IS NOT NULL).

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