HTTP Call error: ORA-24247 Network access denied
I am using Oracle DB 19.10.0.0.0 with EBS 12.1.3 Facing below error when trying to call an http request:
ORA-24247 Network access denied by access control list.
I reviewed Doc ID 1074843.1 but couldn't find any clue about issue. I used below command to create ACL.
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => 'google.com', lower_port => 443, upper_port => 443,
ace => xs$ace_type(privilege_list => xs$name_list('http'),
principal_name => 'APPS',
principal_type => XS_ACL.PTYPE_DB));
END;
Note: calling google.com is a test which clarifies that there is no issue in accessing external urls. Also I used http privilege instead of connect or resolve as per