Total Duration Of Product Dosing Computing Formula (Doc ID 728657.1)

Last updated on SEPTEMBER 06, 2008

Applies to:

Adverse Event Reporting System - Version: 4.5.1
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 4.5.1 in Production:
The total Duration of Product Dosing is computed taking as reference the Dosing From-To dates
of all the products and not only those of the Product for which the automatic computing of Total
Duration is requested.

ERROR
The total duration value is computed for Item “Total Duration” (database field
AE_SUSPECT_DRUGS.TOTAL_DUR_OF_TRTMT) by the Code List “CALC_TOTDUR”
with Code List Executable:
SELECT TO_CHAR((MAX(TO_DATE(TO_DT, 'YYYYMMDD')) -
(MIN(TO_DATE(FROM_DT, 'YYYYMMDD')))) +1) COL1,
'DAYS' COL2 FROM AE_DOSAGES WHERE CASE_ID = :GLOBAL.CASEID

-- Steps To Reproduce:
The issue can be reproduced with the following steps:
1. Open a Case
2. Browse to section “Products” and add a record for a product: for easy reference
    “ASPIRINE”
    In sub-section “Dosing” enter Start Date “25-MAR-2008”, Taken To “03-APR-2008”,
    then double-click on item Duration to have the duration of treatment computed (expected
   10 Days)
3. Remain in section “Products” and add another record for a product: for easy reference
    “BEVACIZUMAB”
    In sub-section “Dosing” enter Start Date “23-MAR-2008”, Taken To “23-MAR-2008”,
    then double-click on item Duration to have the duration of treatment computed (expected
    1 Days)
4. For the same product, in sub-section “Dosing” enter Start Date “25-MAR-2008”, Taken
    To “24-MAR-2008”, then double-click on item Duration to have the duration of treatment
    computed (expected 2 Days)
5. Save data
6. Remaining in section “Products” browse to the “ASPIRINE” record.
    In sub-section “Outcome” double-click on item Total Duration to have the total duration
    of treatment with “ASPIRINE” computed: correct value is 10 Days, while the automatic
    calculation returns 12 Days
7. Remaining in section “Products” browse to the “BEVACIZUMAB” record.
    In sub-section “Outcome” double-click on item Total Duration to have the total duration
    of treatment with “BEVACIZUMAB” computed: correct value is 3 Days, while the
    automatic calculation returns 12 Days.

12 Days is the Total Duration of the overall treatments, not that of each specific product.

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