This content has been marked as final. Show 2 replies
ORACLE error 29273 in FDPSTPLooks like the webservice call is made via HTTPS. Did you make the necessary SSL setup to invoke the webservice securely?
Cause: FDPSTP failed due to ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1029
ORA-28862: SSL connection failed
ORA-06512: at "APPS.CM_TEST_WS_INVOKE", line 19
ORA-06512: at line 1
As this is a SSL call, you need to configure the wallet. Basically if it is a One-way SSL (only webservice server gets authenticated), you need to follow the following steps.
1.) Extract the Public Certificate of the Target Web service from using the browser
2.) Import this certificate in the Oracle Wallet using Oracle Wallet Manager
3.) The schema user trying to invoke the service should have proper ACL permissions
4.) Test your connection from the R12 SQL directly using below SQL statement. If below is success you can wrap the service call in a package.
Let me know if you still face any issues.
select utl_http.request('https://<service URL>', NULL, --Proxy Settings if any 'file:<Wallet_Location>', -- on R12 <Wallet_Password> ) from dual;