'GetUnivDiscrepancy - 286900:No existing unvariate discrepancy for the question..' Error When Trying To Resolve Discrepancy. (Doc ID 423115.1)

Last updated on MAY 20, 2008

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5.1
This problem can occur on any platform.

Symptoms

-- Problem Statement:
RDC 4.5.1:  When trying to manually close a MANDATORY or TMS discrepancy the following error occurs:

ERROR
GetUnivDiscrepancy- 286900: No existing univariate discrepancy for the question


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log into RDC
2. Open the CRF that has the discrepancies.
3. Select Discrepancy management and click on the field with the discrepancy.
4. Select an action (ie Close) and hit OK
5. Error returned: GetUnivDiscrepancy-286900: No existing univariate discrepancy for thie question

TESTCASE 1 (Mandatory Discrepancy Case): 
1.
RDC PDF: Open a document with uses a DCM with two questions (one being MANDATORY).

2.
Specify Investigator comment on Mandatory field.

3.
Specify value on other field.

4.
Save incomplete.


Response data:

RESPONSE_ID    D   DATA_COMMENT_TEXT  VALUE_TEXT   END_TS
-----------    -   -----------------  ----------   ------   
2062403            hello again                     15-AUG-01
2062503                               M            15-AUG-01

5.
Open document again.

6.
Null out investigator comment.

7.
Save Complete > Mandatory discrepancy is created.


However discrepancy_indicator is not populated for the response ie

RESPONSE_ID  D    DATA_COMMENT_TEXT    VALUE_TEXT    END_TS
-----------  -    -----------------    ----------    ---------
2062403           hello again                        01-MAR-07
2062403                                              15-AUG-01
2062503                                M             15-AUG-01



8.
Now specify a value for the MANDATORY question ie 1 > Save.

9.
Discrepancy Management tool : find the Mandatory Discrepancy is still open (even though field is populated with a value) ie

RESPONSE_ID D DATA_COMMENT_TEXT VALUE_TEXT END_TS
----------- - ----------------- ---------- ---------
2062403        hello again                 01-MAR-07
2062403                                    01-MAR-07
2062403                         1          15-AUG-01
2062503                         M          15-AUG-01


10.
- now try to close Mandatory Discrepancy Manually > get the

'GetUnivDiscrepancy - 286900:No existing unvariate discrepancy for the question..' error


TESTCASE 2 (Mandatory Discrepancy Case) :
1.
RDC PDF: Open a document with uses a DCM with two questions (one being a MANDATORY Number question).

2.
Specify Investigator comment on Mandatory field.

3.
Specify value on other field.

4.
Save incomplete.

5.
Open document again.

6.
Null out investigator comment.

7.
Save Complete > Mandatory discrepancy is created.


However discrepancy_indicator is not populated for the response ie

RESPONSE_ID  D  VAL   DATA_COMMENT_TEXT   VALUE_TEXT   END_TS
------------ -  ---   -----------------   ----------   --------
2062803         NNN   not performed                    01-MAR-07
2062803         NNN                                    15-AUG-01

2062903         NNN                        M           15-AUG-01


8.
Now enter 'U' for the Mandatory Question > Save > Data Type Discrepancy is created
and discrepancy_indicator is populated ie

RESPONSE_ID D VAL  DATA_COMMENT_TEXT VAL_TEXT EXC_VAL  END_TS
----------- - ---  ----------------- -------- -------- ------
2062803       NNN  not performed                      01-MAR-07
2062803       NNN                                     01-MAR-07
2062803     U NNN                             U       15-AUG-01
2062903       NNN                     M               15-AUG-01



9.
Now NULL out the Mandatory Question > get MANDATORY Univariate pop-up > Save.

RESPONSE_ID D VAL DATA_COMMENT_TEXT VAL_TEXT EXC_VAL END_TS
----------- - --- ----------------- -------- ------- ------
2062803       NNN  not performed                     01-MAR-07
2062803       NNN                                    01-MAR-07
2062803     U NNN                             U      01-MAR-07
2062803     U NNN                                    15-AUG-01
2062903       NNN                    M               15-AUG-01



Note that the Discrepancy_indicator is carried forward.


10
Now enter '0' which is a Valid number for the Mandatory Discrepancy > Save.
The discrepancy indicator is removed but the discrepancy is still open in RDC

RESPONSE_ID D VAL DATA_COMMENT_TEXT VAL_TEXT EXC_VAL END_TS
----------- - --- ----------------- -------- ------- ------
2062803       NNN   not performed                    01-MAR-07
2062803       NNN                                    01-MAR-07
2062803     U NNN                            U       01-MAR-07
2062803     U NNN                                    01-MAR-07
2062803       NNN                                  15-AUG-01
2062903       NNN                    M               15-AUG-01


11.
Now try to close Mandatory Discrepancy Manually > get the

'GetUnivDiscrepancy - 286900:No existing unvariate discrepancy for the question..' error


CONCLUSION :
Ultimately the issue is the same in both testcases > valid values have been specified for the mandatory questions but the mandatory discrepancies are not closed by the RDC application . When try to manually close the Mandatory Discrepancies then the 286900:No existing unvariate discrepancy for the question..' error is displayed.


TESTCASE 3 (TMS Discrepancy Case) :
1.
Enter a tms response which will not code ie PAROXEN  > save complete the document

2.
Start a Batch Validation run which will invoke TMS processing

3.
PDF document > update tms enterable to NAPROXEN 

4.
Wait for Batch Validation to complete.

RESP_ID   RESP_ENTRY_TS       D VALUE_TEXT END_TS
--------  ------------------  - ---------- -------------------
4800003 04-APR-2008:12:07:33  U PAROXEN    04-APR-2008:12:08:12
4800003 04-APR-2008:12:08:12    NAROXEN    15-AUG-3501:00:00:00




DISC_ENTRY_ID  DISCREPANCY_REV  RESPONSE_ID RESPONSE_ENTRY_TS
-------------  ---------------  ----------- -----------------  
2096403        TMS IN PROGRESS  4800003    04-APR-2008:12:07:33



ie Current TMS Discrepancy is associated with obsoleted response


5.
Now try to close the TMS discrepancy or try to 'send to site' in PDF screen : get the 'GetUnivDiscrepancy - 286900:No existing univariate discrepancy for the question.. error.

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