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

Last updated on FEBRUARY 11, 2019

Applies to:

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
-----------    -   -----------------  ----------   ------   
<RESPONSE_ID>            hello again                     15-AUG-01
<RESPONSE_ID>                               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
-----------  -    -----------------    ----------    ---------
<RESPONSE_ID>       hello again                        01-MAR-07
<RESPONSE_ID>                                          15-AUG-01
<RESPONSE_ID>                            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
----------- - ----------------- ---------- ---------
<RESPONSE_ID>  hello again                 01-MAR-07
<RESPONSE_ID>                              01-MAR-07
<RESPONSE_ID>                   1          15-AUG-01
<RESPONSE_ID>                   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
------------ -  ---   -----------------   ----------   --------
<RESPONSE_ID>NNN   not performed                    01-MAR-07
<RESPONSE_ID>NNN                                    15-AUG-01
<RESPONSE_ID>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
----------- - ---  ----------------- -------- -------- ------
<RESPONSE_ID>NNN  not performed                      01-MAR-07
<RESPONSE_ID>NNN                                     01-MAR-07
<RESPONSE_ID>NNN                     U               15-AUG-01
<RESPONSE_ID>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
----------- - --- ----------------- -------- ------- ------
<RESPONSE_ID>NNN  not performed                     01-MAR-07
<RESPONSE_ID>NNN                                    01-MAR-07
<RESPONSE_ID>NNN                    U               01-MAR-07
<RESPONSE_ID>NNN                                    15-AUG-01
<RESPONSE_ID>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
----------- - --- ----------------- -------- ------- ------
<RESPONSE_ID>NNN   not performed                    01-MAR-07
<RESPONSE_ID>NNN                                    01-MAR-07
<RESPONSE_ID>NNN                    U               01-MAR-07
<RESPONSE_ID>NNN                                    01-MAR-07
<RESPONSE_ID>NNN                    0               15-AUG-01
<RESPONSE_ID>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 <TERM1>> save complete the document

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

3.
PDF document > update tms enterable to <TERM2>

4.
Wait for Batch Validation to complete.

RESP_ID   RESP_ENTRY_TS       D VALUE_TEXT END_TS
--------  ------------------  - ---------- -------------------
<RESPONSE_ID>04-APR-2008:12:07:33  U <TERM1>04-APR-2008:12:08:12
<RESPONSE_ID>04-APR-2008:12:08:12    <TERM2>15-AUG-3501:00:00:00



DISC_ENTRY_ID  DISCREPANCY_REV  RESPONSE_ID RESPONSE_ENTRY_TS
-------------  ---------------  ----------- -----------------  
<DISCREPANCY_ID> TMS IN PROGRESS  <RESPONSE_ID> 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.

Changes

Cause

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