Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
SOAP call to AccountCombinationService via APEX_WEB_SERVICE.make_request returns null — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SOAP call to AccountCombinationService via APEX_WEB_SERVICE.make_request returns null

Received Response
3
Views
2
Comments
edited Sep 10, 2021 9:02AM in Integrations and Extensions 2 comments

Summary

Using APEX_WEB_SERVICE.make_request to call fscmService/AccountCombinationService but the response returned is NULL

Content

Doing a SOAP call with the payload (listed in bottom) in Postman is working fine.
But when I try to execute same payload from the Oracle database (APEX) via APEX_WEB_SERVICE.make_request it returns NULL.
It should return an XMLTYPE document. I have seen similar issue calling other SOAP services which I solved with fixing the g_request_headers.
But it still does not work for me in this case.
 
Code snippet;
  apex_web_service.g_request_headers.delete; 
  apex_web_service.g_request_headers(1).name := 'Content-Type';

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!