Cannot Enter A New Site Via Maintain Test Sites Form - Error FRM-40508 (Doc ID 1369986.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.6.2 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.

Goal

Trying to enter a test mode site via the Maintain Test Sites form and receive the message:

Error
--------
FRM-40508 - Oracle error: unable to insert record.

Steps To Reproduce
-----------------------
1. OC -> Design -> Test a Study Design -> Sites
2. Enter Site Code = TEST_INDEX, Name = TEST_INDEX, Phone Number, etc
3. Save => Successful
4. Click on new line and enter Site Code= TEST_INDEX (get message duplicate value as it's a unique key)
5. Enter Site Code = TEST_INDEX2, Name = TEST_INDEX (same as previous inserted record)
6. Save => Receive error (FRM-40508 - ORACLE error: unable to INSERT record)
7. Change the Name field to TEST_INDEX2
8. Save => Now saved successfully



Solution

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