My Oracle Support Banner

Autonomous Database (ADB) - The apex_util.create_user creation failing with ORA-20001: Package variable g_security_group_id must be set (Doc ID 2733774.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A and later
Information in this document applies to any platform.

Symptoms

In autonomous database (ADMIN user), the Application Express user account creation failing with ORA-20001: Package variable g_security_group_id must be set

 

SQL> declare
l_workspace_id number;
begin
l_workspace_id := apex_util.find_security_group_id (p_workspace => 'ADWS');
apex_util.set_security_group_id (p_security_group_id => l_workspace_id);
apex_util.create_user(p_user_name=>'apexuser',p_first_name=>'Nishanth',p_last_name=>'Balan', p_description=>'pco',p_email_address=>'xx.xx@xxx', p_web_password=>'Oxxx1234##');
end;
/ 2 3 4 5 6 7 8
declare
*
ERROR at line 1:
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_200100.WWV_FLOW_API", line 455
ORA-06512: at "APEX_200100.WWV_FLOW_API", line 490
ORA-06512: at "APEX_200100.WWV_FLOW_FND_USER_INT", line 1891
ORA-06512: at "APEX_200100.HTMLDB_UTIL", line 1452
ORA-06512: at line 6

 

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


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