We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
edited Sep 10, 2021 9:02AM in Integrations and Extensions 2 comments


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


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(1).name := 'Content-Type';

Howdy, Stranger!

Log In

To view full details, sign in.


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