Check the OpenID Configuration - Version 2020 (10.0)

To check if the database is able to connect to the OpenID servers, perform the following commands:

MS Azure:

select apex_web_service.make_rest_request(p_url => 'https://graph.microsoft.com/v1.0/me/',p_http_method => 'GET') from dual;

select apex_web_service.make_rest_request(p_url => 'https://login.microsoftonline.com/',p_http_method => 'GET') from dual;

OKTA:

In this command, replace <sandbox.intergraphsmartcloud.com> with your server name:

select apex_web_service.make_rest_request(p_url => 'https://<sandbox.intergraphsmartcloud.com>/',p_http_method => 'GET') from dual;

The above queries will return a JSON / WEB response, which might return something like this, for example:

{"error":{"code":"InvalidAuthenticationToken","message":"Access token is empty.",…

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"http://www.w3.org/TR/html4/strict.dtd><HTML><HEAD><TITLE>Bad Request</TITLE>..

This is not an error, this is a correct response, proofing the ability to connect to the OpenID servers.

If an error message appears like ORA-#####, like this:

ORA-29273: HTTP request failed

then please execute this command:

select utl_http.get_detailed_sqlerrm from dual;

Possible errors and their probable causes are:

ORA-24247: network access denied by access control list (ACL)

ORA-29024: Certificate validation failure

Check the OpenID Configuration - Version 2020 (10.0) - Hexagon