My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.