Find And Fix Script For Patch 220.127.116.11 Is Not Picking All The Records For Patient
Last updated on DECEMBER 15, 2010
Applies to:Oracle Clinical Remote Data Capture Option - Version: 4.5.3
Information in this document applies to any platform.
They found that there was update in the RECEIVED_DCIS table for these two records after patient transfer and therefore the find condition is not picking these records.
This looks to be the following bug:
The output of the below query in <
rdci1.DCI_BOOK_ID, rdci2.DCI_BOOK_ID, rdci2.PATIENT, ds1.NAME, ds2.NAME
from received_dcis rdci1, received_dcis rdci2 , dci_books ds1 ,
WHERE rdci1.RECEIVED_DCI_STATUS_CODE = 'REMOVED'
AND rdci2.RECEIVED_DCI_STATUS_CODE != 'REMOVED'
AND rdci1.RECEIVED_DCI_ID = rdci2.RECEIVED_DCI_ID
AND rdci2.END_TS = to_date(3000000,'J')
AND rdci1.clinical_study_id = 103 --studyid
AND rdci1.DCI_BOOK_ID IS NOT NULL
AND rdci2.DCI_BOOK_ID IS NULL
--AND rdci1.end_ts = rdci2.RECEIVED_DCI_ENTRY_TS
AND ds1.DCI_BOOK_ID = rdci1.DCI_BOOK_ID
AND ds2.DCI_BOOK_ID(+) = rdci2.DCI_BOOK_ID;
Can these records be skipped? If not, how can they update these two records?
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