BATCH DATA LOAD FAILS WHEN VISIT NUMBER 5 DIGITS LONG (Doc ID 1079651.1)

Last updated on FEBRUARY 11, 2013

Applies to:

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

Symptoms

Batch Load fails if Visit No is greater than 32767.

Steps to Reproduce:

  1. Select a study already created.
  2. Go to: 
    1. Oracle Clinical
    2. Design
    3. Studies
    4. Easy Study Design
  3. Focus on the Study to be used to upload the data
  4. Click on Events
  5. Change "Visit No" to 32768
  6. Save.
  7. Upload a Document to any DCI included in the Visit modified.
  8. Job fails with error
    ORA-00001: unique constraint (RXC.RECEIVED_DCM_UK2_IDX) violated

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