title: oracle 19c apex 19.1 openid connect configuration error ORA-24247: network access denied by access control list (ACL)
body: <p>I have created a new application is APEX 19.1 by selecting <code>Access Control Enable role-based user authorization</code> feature. The default Authentication Schemes <code>Application Express Authentication</code> works just fine. But when I change it to OpenID Connect and run the app, I get the following error</p>
  <pre><code>- ora_sqlerrm: ORA-29273: HTTP request failed
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 1283
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 924
  ORA-24247: network access denied by access control list (ACL)
  ORA-06512: at &quot;SYS.UTL_HTTP&quot;, line 380
  ORA-06512: at &quot;SYS.UTL_HTTP&quot;, line 1148
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 902
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 1136
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 1473
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEBSERVICES_API&quot;, line 416
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_SOCIAL&quot;, line 79
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_SOCIAL&quot;, line 145
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_SOCIAL&quot;, line 244
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_NATIVE&quot;, line 485
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_NATIVE&quot;, line 1256
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_PLUGIN&quot;, line 2840
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION&quot;, line 1970
  </code></pre>
  <p>and this is the error backtrace</p>
  <pre><code>- error_backtrace: ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 1283
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 924
  ORA-06512: at &quot;SYS.UTL_HTTP&quot;, line 380
  ORA-06512: at &quot;SYS.UTL_HTTP&quot;, line 1148
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 902
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 1136
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEB_SERVICES&quot;, line 1473
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_WEBSERVICES_API&quot;, line 416
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_SOCIAL&quot;, line 79
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_SOCIAL&quot;, line 145
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_SOCIAL&quot;, line 244
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_NATIVE&quot;, line 485
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION_NATIVE&quot;, line 1256
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_PLUGIN&quot;, line 2840
  ORA-06512: at &quot;APEX_190200.WWV_FLOW_AUTHENTICATION&quot;, line 1970
  ORA-06512: at &quot;APEX_190200.WWV_FLOW&quot;, line 4058
  </code></pre>
  <p>I have tried the following way to solve the error</p>
  <pre><code>BEGIN
      DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
          host =&gt; '*',
          ace =&gt; xs$ace_type(privilege_list =&gt; xs$name_list('connect'),
                             principal_name =&gt; 'apex_db_user',
                             principal_type =&gt; xs_acl.ptype_db));
  END;
  /
  </code></pre>
  <p>The statement does proceed but I get the same error.</p>
  <p>Then I thought maybe because I am not using SSL. So I have changed the default.xml file and added the following entry</p>
  <pre><code>&lt;entry key=&quot;security.verifySSL&quot;&gt;false&lt;/entry&gt;
  </code></pre>
  <p>I am new to APEX so probably I am missing something. Is the feature <code>Access Control Enable role-based user authorization</code> enough?</p>