Find Script For 'BUG:8925493 - DCI BOOK ID IS NULL AFTER TRANSFER OF PATIENTS' (shipped in 4.5.1.76) Does Not Detect Records Which Have Subsequently Been Versioned. How Can I Get The New Find Script?

(Doc ID 1253976.1)

Last updated on OCTOBER 26, 2010

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Goal

The 4.5.1.76 iPatch contains the fix for 'BUG:8925493 - DCI BOOK ID IS NULL
AFTER TRANSFER OF PATIENTS'. Find/fix scripts were provided to correct
existing data. However the 'cRdcis' cursor in the find script (findupdbookpattrn.sql) will
not pick up cases where the record which had the dci_book_id nulled out has
been subsequently versioned.

Solution

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