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.
Issues with the DLP Data Update Script During Upgrade
|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|
Bug 28375813 - For a case that only has Trimester completed and if multiple trimesters areselected 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
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_DRUGS (trimester issue)
Apart from these, the below is impacted for the trimester issue:
No code changes done to Argus Mart
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