My Oracle Support Banner

ORA-00001: Unique Constraint (APEX_200200.WWV_REMOTE_SRVR_WS_NAME_UK) Violated, Creating Data Source (Doc ID 2790541.1)

Last updated on JULY 08, 2021

Applies to:

Oracle Application Express (APEX) - Version 20.2 and later
APEX Application Development - Version NA and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : APEX 20.2 version, APEX Bilder

When attempting to create a new REST Data Source
the following error occurs.

ERROR
-----------------------
ORA-00001: unique constraint (APEX_200200.WWV_REMOTE_SRVR_WS_NAME_UK) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In an application go to Shared Components and then to REST Data Sources (RDS)
2. Try to create a new RDS filling up all the pages and even doing the discovery which works okay
3. Click on [Create REST Data Source] button and get error


Changes

 Creating new REST DATA Sources

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
Changes
Cause
Solution


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