My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Clinical - Version 4.6 to 4.6.5 [Release 4.6.0 to 4.6.5]
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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.