Orphaned 'TMS IN PROGRESS' Discrepancies remain after retiring the TMS Related Derivation Procedure in Oracle Clinical.

(Doc ID 760571.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle Clinical - Version 4.5.1 and later
Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Oracle Thesaurus Management System - Version 4.5.1 and later
Information in this document applies to any platform.



1) Set up a TMS/OC Derivation configuration similar to below:

Questions in QG/DCM:



No Question Set assigned



Meddra Question Set assigned

LLTL Derived
LLTC Derived
PTL Derived
PTC Derived 
SOCL Derived 
SOCC Derived 

Question AETRT in above is linked to MEDDRA Question Set
with linked derived Questions LLTL, LLTC, PTL, PTC, SOCL, SOCC, VERSION)

Derivation procedure was created to Derive values manually entered in AETERM directly into AETRT which is then validated against TMS Meddra Question Set to create omissions and
derive back data.

Later a change of design amended the definition to enter directly into AETRT so that AETERM was no longer required.

To do this switched the Question Set to Question AETRT from AETERM and retired question AETERM, and made derivation procedure that previously populated retired.

However this can result in TMS IN PROGRESS discrepancies against old parent/retired Question AETERM, which can no longer be updated/closed.


2) When this issue occurs then the following errors can also appear in the Remote Data Capture application => Data Entry Window :

The data entry window has encountered an unexpected error and
will shut down. If the problem recurs, please report the following
information for diagnostic purposes:
Log code xxxxxx, internal error


Invalid JSON received


and the log.xml / dump file contain errors like :

Exception Details:SQL Exception. Unable to proceed further.
oracle.pharma.rdc.de.exception.FailedOperationException: SQL Exception. Unable to proceed further.
    at oracle.pharma.rdc.de.service.dcs.RDCI.populateDiscrepancies(RDCI.java:1333)
    at oracle.pharma.rdc.de.service.dcs.DciFormData.populateDiscrepancyDetails(DciFormData.java:9119)
    at oracle.pharma.rdc.de.service.dcs.DataCaptureService.performAction(DataCaptureService.java:389)
    at oracle.pharma.rdc.de.service.dcs.DataCaptureService.processCommand(DataCaptureService.java:252)
    at oracle.pharma.rdc.de.servlet.RuntimeController.doPost(RuntimeController.java:608)

Caused by: java.sql.SQLException: ORA-20001: Could not find data for discrep id xxxxxx
ORA-06512: at "RXC.OCL_DISC", line 576
ORA-06512: at "RXC.OCL_DISC", line 667

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)


Retire a Derivation Procedure against a TMS Validated Question


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