Duplicate record in data extract view created after subevent change via key change. (Doc ID 1303604.1)

Last updated on SEPTEMBER 28, 2012

Applies to:

Oracle Clinical - Version 4.5.1 to 4.6.0 [Release 4.5.1 to 4.6.0]
Information in this document applies to any platform.

Symptoms

Go to key changes. Change subevent for a given record from 0 to 1 and save.
The record now appears twice in the received_dcis table with status REMOVED and PASS 1 COMPLETE (as expected), but the record also appears twice in the SAS data extract view both with subevent 1, but with different page numbers.

There are no duplicates in the CURRENT view. The duplicates already appear in the Oracle views, such as the TEST access account. For example, on view APOG6888$TEST.LBLBB.

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