Error In UTL_HTTP.REQUEST ORA-24247: Network Access Denied By Access Control List (ACL) (Doc ID 1467588.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Information in this document applies to any platform.
*** 7/22 currency check

Symptoms

The "UTL_HTTP" package is been used to make callouts from SQL and PL/SQL and access access data on the Internet over HTTP using SOAP requests.

It is invoking a custom Composite Webservice.

The following error occurs when running the PL/SQL block containing the HTTP request.

Error report:

 

Further investigation has revealed that the following simple Select statement also gives the same error.

select utl_http.request('http://www.google.com') from dual;

Fusion Applications version 11.1.1.5.1 is been used connecting to 11G database.

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