OCDA_INFA_Stdy_Enrlmnt_Pln_SIL_PRG Fails with ORA-02299 Duplicate Keys Found (Doc ID 1390494.1)

Last updated on JANUARY 03, 2012

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version: 2.0 and later   [Release: 2.0 and later ]
Information in this document applies to any platform.

Symptoms

Submitting OCDA_PLS_LEVEL2_FACT_PRG manually, it fails on one of the child programs
OCDA_INFA_Stdy_Enrlmnt_Pln_SIL_PRG with the following error message:

Error Code: -2299:: Error Description: ORA-02299: cannot validate (CDR_WB_1C2ED09F.T473340111_3__UK) - duplicate keys found
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 7531
ORA-01403: no data found::2:


Changes

Upgrade OCDA 2.0 to 2.0.0.3

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