Integrating With Fusion Application Using Services (APEX)

Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for a logical business object and provide functionality to access and manipulate these objects. The composite services are mostly process oriented and provide an orchestration of multiple steps.  

Information about the web services provided by Fusion Applications is hosted in Oracle Enterprise Repository (OER). The information provided by OER can be used to understand the functionality provided by the service and how the service can be called.

This series of articles describes how one can invoke SOAP web services provided by Fusion Applications using various technologies. In this article we will cover how to invoke a Fusion Application web service using Oracle Application Express (APEX).


Oracle Application Express (APEX) on-premises environment or Oracle Cloud Database Service needs to be available.

Implementing Web Service Call

Oracle Application Express (APEX) is a software development platform on the database level. Web services can be integrated to APEX applications using "Web Service Reference" objects that work on top of the APEX_WEB_SERVICE API. Details on how to create and use web service references can be found in this presentation. First we need to construct a valid SOAP envelope to be used for the web service call, in this example we will query a employee name based on employee number (replace the username and password from the content):

<soapenv:Envelope xmlns:soapenv="" xmlns:typ="" xmlns:typ1="">
      <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="">
          <wsse:UsernameToken wsu:Id="UsernameToken-2" xmlns:wsu="">
          <wsse:Password Type="">password</wsse:Password>
          <wsse:Nonce EncodingType="">jwCzGGijT90Wml6eZe4cxg==</wsse:Nonce>

In your APEX application navigate to "Shared Components -> Web Service References -> Create" and choose Manual on the first screen:

On the Web Service Reference screen we will define the details of how the service will be invoked:

When defining the reference for a Fusion Applications ADFbc service use values such as:





This is the URL for WSDL for the Fusion Applications ADFbc service



This is the definition of the service and operation including the namespace

SOAP Envelope

This defines the content to be passed to the service. The value needs to be complete SOAP envelope to invoke the service with. Bind variables can be defined by having and upper case string with hash pre and post fix. In the example case we have a "#PERSON_NUMBER#" bind variable. The bind variables can be used in the application to obtain input from the user using an input field. The value of the input field would be used to replace the bind variable on the SOAP content when submitting the request to the service

Enter the content we constructed earlier

Store Response in Collection

This is a temporary structure containing the response from the Web Service call. This object can be used to parse the response XML to be used in the application.

Set to any unique value

Next we create UI for the new web service references, click "Create Form & Report on Web Service":

On next screen choose the web service reference that we created:

On the following screens simply accept the defaults until the “Web Service Results” screen:

When defining the results use values such as:




Result Node Path (XPath)

This is a XPath expression that can be used to derive the data we are interested in from the response. In the example the response will contain the results in a element names “PersonName”


Message Namespace

This defines the namespace used with the XPath

On the next screen add the "LastName" and "FirstName" to be displayed on the resulting report. Elements matching these names must exist under the "Result Node Path" defined in previous step:

For the next screens accept the defaults, once finished navigate to the application page and run the new page:

On the opened report we can query employees using the web service reference:


In this article we covered an example using APEX to integrate with Fusion Applications using web services. In future articles other technologies for invoking Fusion Applications web services will be covered.



Hi Jani,

This is great info! Earlier we had the experience (but with an older Fusion version) that not all web services found in the OER are to be used for intergration. For instance "Locations" then was only for internal use between parts of Fusion itself and could not be reached from outside of Fusion. Do you know if there is any information which of the services can be used for integration with other applications outside of Fusion and which are only for internal use?

Posted by guest on May 16, 2014 at 03:23 AM PDT #

You are right OER contains all internal and external services. The external services are indicated with the keyword "EXTERNAL" on the taxonomy tab. See this blog post:

at the end there is a screenshot of the field. You can also use the keyword in searches by clicking "More Search Options" in the OER search UI (note that the window sometimes may take time to render), check the "
Filter by Additional Criteria" checkbox, choose the "keywords" as the field, "equals" as the operation and "EXTERNAL" as the value. Hope this helps..

Posted by Jani Rautiainen on May 16, 2014 at 08:14 AM PDT #

Ah, Thanks Jani, that is very helpful!

Although disappointing as well, since we are looking for integrations with HCM. It appears when selecting only on External and HCM, I'm only getting file based integrations, and nothing with messaging so far.

Hopefully in future releases.
Thanks for your help anyways!

Posted by Stefan van Glabbeek on May 16, 2014 at 08:52 AM PDT #

We can't comment on future releases, but we are hopeful as well

Posted by Jani Rautiainen on May 16, 2014 at 10:19 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow us on twitter Fusion Applications Extensibility, Customizations and Integration forum Fusion Applications Dev Relations YouTube Channel
This blog offers news, tips and information for developers building extensions, customizations and integrations for Oracle Fusion Applications.


« July 2016