I am using Oracle APEX to make a remote web request to the JIRA Rest API. I have set up a wallet and am using the following code:
apex_web_service.g_request_headers(1).name := 'Content-Type';
apex_web_service.g_request_headers(1).value := 'application/json';
apex_web_service.g_request_headers(2).name := 'Authorization';
apex_web_service.g_request_headers(2).value := 'Basic [USERNAME]:[PASSWORD]';
l_response := apex_web_service.make_rest_request (
p_url => 'https://lozier.atlassian.net/rest/api/2/issue',
p_http_method => 'POST',
p_body => l_jira_request,
p_wallet_path => '/oracle/db/wallet',
p_wallet_pwd => 'erptestwallet1'
);
However, when I run this code, I am getting the following error -- ora-29024 certificate validation failure -- and, making a web request through Curl/APEX has not worked for any other team members. Are there any database configurations that could be hindering this process?