My Oracle Support Banner

Social Sign In For Apex Builder - Error Stack: ORA-01400: cannot insert NULL into (""APEX_190200"".""WWV_FLOW_SESSION_GROUPS$"".""GROUP_NAME"") (Doc ID 2665472.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 19.2 and later
Information in this document applies to any platform.


When applying the latest patch for apex 19.2 in an attempt to get Social Sign in working for the Builder and Internal workspace. When attempting to set this a PLSQL error when hitting the login patch for APEX. Trying to set the flag to rollback the auth scheme to APEX is no longer working.

exec apex_instance_admin.set_parameter('APEX_BUILDER_AUTHENTICATION','APEX');

Also tried to get the get_parameter to try and understand what it is currently set at today and this command is not working either.


When a baseline command to create a dynamic group manually with that command and using an authorization to check the group created in that dynamic group by doing something like below:

procedure load_dynamic_groups as
apex_authorization.enable_dynamic_groups (
p_group_names => apex_t_varchar2('CRE|SMC-CONTRACT-DEV|CRE~CONTRACT') );

Now the code in the example is creating the load_dynamic_group, mapping l_group_names table to the apex_t_varchar2 and trying to do something with the json.getcount and inserting those values with apex_string.push into the table.



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.