Oracle UTL_HTTP Certificate validation failure on SSL certificate

See more:

SQL

Oracle

security

SSL

Got a SSL certificate , imported via Oracle Wallet Manager as well as orapki command line.

want to get Json string from https of website ( set the below Json string as random string , you can pick any other Json string )
i have set wallet store of oracle in E:\wallet folder .

I have done certificate ACL creation and adding in oracle .

set define off;

select utl_http.request('https://api.abc.com/flex/status/rest/v2/json/aaa/status/ZH/9854/dep/2015/06/28?appId=d84d17f8&appKey=613e9804c66069a037a10ee671920712&hourOfDay=0&utc=false&codeType=FS', null, 'file:e:\wallet', null) from dual;

off;

Got the error as :

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29024: Certificate validation failure
ORA-06512: at line 1
29273. 00000 -  "HTTP request failed"
*Cause:    The UTL_HTTP package failed to execute the HTTP request.
*Action:   Use get_detailed_sqlerrm to check the detailed error message.
           Fix the error and retry the HTTP request.

Unable to get Exact JSon string ...