APEX Web Service Calls Fail For TLS With in 11.2.0.2 SSL: ORA-28857: Unknown SSL Error (Doc ID 2033910.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 4.2.4 version of Application Express with the following setup:

Database Version 11.2.0.2
Package: apex_web_services
Function: make_rest_request
REST Services are connection: TLS 1.2 (Details in screen shot)

An APEX application has been running with an SSL web service successfully. Recently the web service has been modified to use TLS 1.2.
Since that change, the web service requests have been failing with the following error:


All other web service and UTL_HTTP calls run successfully from SQL*Plus and from APEX. This problem is specific to TLS requests.

Changes

 The vendor has changed their web service from SSL to TLS.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms