My Oracle Support Banner

PAT_EXPOSURE AND PRODUCT_ID Populated Incorrectly (Doc ID 2882516.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.2.2 and later
Information in this document applies to any platform.

Symptoms

When importing the follow up for Study cases, the CASE_PRODUCT.PRODUCT_ID is getting populated.

This should not be the case as CASE_PRODUCT.PAT_EXPOSURE value is already populated for the study drug.

STEPS:
1) Import an Initial File that has a Study ID
2) Once the file is imported and the case is accepted successfully the users go into Products and Select the Study Drug.
Pat_Exposure is populated for study drugs.

EXAMPLE:
select case_id, product_id, pat_exposure from case_product
where case_id = 102575

CASE_ID   PRODUCT_ID  PAT_ EXPOSURE
102575    (null)              100038
102575    100038           0


3) Import a Follow up for the case.
    After the import- product_id is also populated.

CASE_ID   PRODUCT_ID  PAT_ EXPOSURE
102575    100038            100038
102575    100038            0

 

Changes

 

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
References


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