My Oracle Support Banner

Values not updated in ‘IRV_CUR_SUBJECT’ table in INFORM Operational data in DMW (Doc ID 2521753.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 to 2.4.8.1 [Release 2.4]
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Health Sciences Data Management Workbench (DMW) 2.4.8.1 version,

ACTUAL BEHAVIOR
------------------
Values are not updated in ‘IRV_CUR_SUBJECT’ table from INFORM Operational data in DMW.
The values ‘BOOKSIGN’ = Not Null (Date) and ‘COUNTBOOKFROZEN’ = 1 are not getting populated for the studies created in DMW v2.4.7.7 and upgraded to DMW v2.4.8.1.

These values are getting updated in ‘IRV_CUR_SUBJECT’ table in INFORM Operational data in DMW for the new studies created in DMW v2.4.8.1 and the data loaded in DMW.


EXPECTED BEHAVIOR
-----------------------
The values ‘BOOKSIGN’ = Not Null (Date) and ‘COUNTBOOKFROZEN’ = 1 should be updated in ‘IRV_CUR_SUBJECT’ table in INFORM Operational data in DMW when a casebook for a subject is frozen in INFORM.


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Create an InForm study in DMW 2.4.7.7
2. Verify the values loaded in IRV_CUR_SUBJECT table.
3. Upgrade DMW to DMW 2.4.8.1 version.
4. Verify the values loaded in IRV_CUR_SUBJECT table.


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
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.