My Oracle Support Banner

DLP Data Change Update Script Issues During Upgrade to 8.1.x (Doc ID 2449250.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Argus Safety - Version 7.0.0 to 8.1.2 [Release 7.0.0 to 8.1]
Information in this document applies to any platform.

Symptoms

 Issues with the DLP Data Update Script During Upgrade

Changes

 

Oracle Argus Safety - Upgrade to 8.1 (7.0x/8.0x to 8.1)
NO. ISSUE DESCRIPTION FIX DETAILS
1 While reviewing all the updates to DLP from ARGUS for the upgrade, it was noted that DLP_CASE_MEDWATCH_DATA and DLP_CASE_PAT_RACE table data population logic is not referring to the DLP tables instead it was using CASE_MEDWATCH_DATA and CASE_PAT_INFO synonyms which does not return any data when executed as dlp_user Script dlp_81_data_change1.sql has been updated to use the DLP tables instead of synonyms.
2 This script is ONLY migrating revisions into the new table for which the main column(s) of interest is not NULL. As a result, revisions in the target DLP tables are created which are not necessarily in continuous sequence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE Migrate all the revisions for a set (set = revisions of same case_id or same case_id, seq_num) into the new table if any column of interest has a not NULL value
3

Bug 28375813 - For a case that only has Trimester completed and if multiple trimesters are

selected then the upgrade script picks the last trimester.

For a case that only has Trimester completed and if multiple trimesters are selected then the upgrade script picks the earliest trimester

i.e.

If first and second and/or third trimester is checked, then CASE_PROD_DRUGS.EXPOSURE= 1  and CASE_PROD_DRUGS.EXPOSURE_UNIT= value of Trimester

If second and third trimester is checked,  then CASE_PROD_DRUGS.EXPOSURE= 2  

and CASE_PROD_DRUGS.EXPOSURE_UNIT= value of Trimester.

 

It also populates appropriate revisions to the DLP tables.

List of DLP tables impacted due to the changes:

DLP_CASE_PROD_COMPONENT

DLP_CASE_MEDWATCH_EVAL

DLP_CASE_MEDWATCH_PATDEV

DLP_CASE_PROD_DEV_EVAL

DLP_CASE_PROD_DEV_PATDEV

DLP_CASE_PAT_RACE

DLP_CASE_PROD_DRUGS (trimester issue)

 

Apart from these, the below is impacted for the trimester issue:

CASE_PROD_DRUGS

 

No code changes done to Argus Mart

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.