My Oracle Support Banner

ORDS Web Service API Is Failing Wrapping the APEX PL/SQL APIs for Workspace User Created (Doc ID 3049939.1)

Last updated on SEPTEMBER 26, 2024

Applies to:

Oracle Retail Data Storage Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Goal

On: ORDS 24.1.101.0 version

The users have created ORDS Webservice API in RDS to call the PL/SQL APIs: CREATE_USER-Procedure


To create Users in <WORKSPACE_NAME_VALUE_1> Workspace.

When calling webservice to test, it fails and giving below error.

Out[21]: '{"Exception" : "ORA-20987: APEX - User <WORKSPACE_NAME_VALUE_1> requires ADMIN privilege to perform this operation."}'


Below is webservice the users have created in RDS Stage
https://<URL>/CreateWorkSpaceDeveloper

This API is just to create APEX User.

It has seen in Workspace, <WORKSPACE_NAME_VALUE_1> is workspace administrator.

Whenever the users invoke the same Package using a PL/SQL block in SQL Commands section in RDS APEX VIEWER it is working fine.
 

Solution

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
Goal
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.