My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Clinical - Version 4.6.2 and later
Information in this document applies to any platform.


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

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


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

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