Skip to main content
Feedback

Oracle Fusion operation

The Oracle Fusion connector operation imports and executes SOAP services.

Create a separate operation component for each action/object combination that your integration requires.

The Oracle Fusion connector operations use XML format and support the following actions:

  • EXECUTE
  • QUERY
note

The data handled by the Oracle Fusion connector must be of the limited size as per framework.

Options tab

Select a connector action, then use the Import Wizard to select the object to integrate. When you configure an action, the following fields appear on the Options tab.

Connector Action (EXECUTE, QUERY) - Refers to the action type selected in connector configuration. This field is auto populated by the Boomi Enterprise Platform.

Object - An object defines what you want to integrate or the action to run, which you select in the Import Operation wizard.

Request/Response Profile - The XML profile definition that represents the structure sent or received by the connector.

Tracking Direction - Select the document tracking direction for the operation, either Input Documents or Output Documents. This setting enables you to choose which document appears in Process Reporting. Start steps always track output documents regardless of your selection.

note

If the tracking direction is read-only, the feature to change the direction is either unavailable or the developer set the configuration to read-only. The default value you see shows you which document appears in Process Reporting.

Return Application Error Responses - This setting controls whether an application error prevents an operation from completing:

  • If you clear the setting, the process stops and reports the error on the Process Reporting page.
  • If you select the setting, processing continues and passes the error response to the next component processed as the connection output.

SOAP envelope for response profile (EXECUTE, QUERY) - Refers to the setting that controls if the SOAP response should include the <Header> element or not. If selected, the connector includes the <Header> element to the SOAP envelope of the process response. Otherwise, the response will be published without the header.

Fetch Start (QUERY)
Refers to the starting position of the record in the service. The default value is 0.

Fetch Size (QUERY) - Refers to the total number of records/responses to be fetched from the service within a single transaction. The default value is -1.

Batch Size (QUERY) - Refers to the number of records/responses to be fetched per request within a single transaction. The default value is 0.

note

You can fetch records in batch until you reach the maximum number of counts instead of fetching all records at time within the single transaction. For instance, if the maximum number is 10 and as the fetch size and the batch size is 2, then only 2 records are fetched each time until the fetch size is 10.

Common Profile Generation (EXECUTE, QUERY)

  1. Click on the Import button to create request and response profiles.

  2. Select the Runtime and Connection and then select Service Operation, Service Name or enter (CUSTOM SOAP WSDL Relative URL) SOAP WSDL Url while fetching operations respectively to be displayed as object types (createLocation for EXECUTE, findLocation for QUERY etc).

note
  • Not all the services under Service Name are listed.
  • Make sure to have necessary access permission to execute the service selected for the given service operation. This must be configured in the Oracle Fusion environment. - Import based on the Action displays an error message if there is no SOAP operation associated with that specific Action (EXECUTE or QUERY).
  • When Custom is selected for Service Operation from the dropdown, Custom SOAP WSDL Relative Path field is displayed and Service Name field is hidden and, vice versa for any other Service Operation other than Custom.
  • Make sure to enter relative path for the CUSTOM SOAP WSDL Relative URL field.

  1. Select Import Options and Object Type and click on Next button.
    The request and response profiles are then generated.

  2. Click on Finish to view the profiles.

note
  • Setup any of the SOAP service operation with request and response profiles while performing EXECUTE/QUERY action in the process.
  • For QUERY operation:
  • Set up filters as input parameters and values for expressions/parameters from UI.
  • Select parameters for sorting.
  • Select certain fields as response fields instead of all fields in the response.
  • If you modify the connection details (Fusion Endpoint URL/User Name/Password), make sure to reimport the profile for the respective operations.

EXECUTE

The Oracle Fusion connector implements EXECUTE action to perform specific task on APIs or operations. This action allows you to send the input data in terms of request payload XML with the SOAP format and includes both the request and response profiles. EXECUTE fetches the response for the following types of operations:

  • CREATE: To create new business data.
  • GET: To retrieve business data.
  • UPDATE: To update business data.
  • DELETE: To delete business data.
  • MERGE: To merge data of two services.
  • CUSTOM: To perform any operation apart from the ones mentioned above. For example: submit, upload etc.
  • PROCESS/PROCESSCS: Any of the processes. For example: Create operation data etc.

To add the SOAP <Header> element to the process response, use the SOAP envelope for response profile check box available on the Operation – Options tab. This feature is supported in both Execute and Query operation.

QUERY

The Oracle Fusion connector implements QUERY to perform specific tasks on APIs or operations. This action allows you to select the parameters from response profile as a query/input data/request parameters/values for those parameters and includes only response profiles. QUERY fetches the response for the following specific type of operations:

  • FIND or FINDFILTER: To fetch business data from the fusion system based on various search criteria.

Features of QUERY operation:

  • Single Parameter Request: This feature allows you to send single parameter in the request payload.
  • Multi Parameter Request: This feature allows you to send multiple parameters in the request payload. For example: If you want to fetch the data based on more than one condition i.e. location ID and country, then you can use either AND or OR condition.

For Single and Multiple Parameter requests, QUERY operation includes:

  • Filters : Filters are used to fetch specific data. Filters include the following:

    • Filter Name: Expression
    • Field: Field in the profile
    • Operator: Comparator between field and value
note
  • Use Logical Subgroup for multi parameter request.
  • Add or delete any expression or logical subgroup based on your requirements.
  • Fields: You can select certain fields for response instead of fetching all fields in the response. Add some filters to a request for any service to retrieve the data based on the filter.
  • Sorts: You can select parameters for sorting in either ascending or descending order.
note

Sorting is not currently applicable to Time/Date field.

Sample request and response profiles

Below are the request and response profiles for EXECUTE : Create operation:

<soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/ xmlns:typ=http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/ xmlns:loc=http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/ xmlns:par=http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/ xmlns:sour=http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/sourceSystemRef/ xmlns:loc1=http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/>
   <soapenv:Header/>
   <soapenv:Body>
      <typ:createLocation>
         <typ:location>
            <loc:CreatedByModule>HZ_CPUI</loc:CreatedByModule>
            <loc:Address1>510 Quercia Marcozzi</loc:Address1>
            <loc:Address2>Building 300</loc:Address2>
            <loc:City>Caserta</loc:City>
            <loc:Country>IT</loc:Country>
            <loc:State>CE</loc:State>
            <loc:PostalCode>90102</loc:PostalCode>
         </typ:location>
      </typ:createLocation>
   </soapenv:Body>
</soapenv:Envelope>

Below is the Create Location Response without Header.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<ns0:createLocationResponse xmlns:ns0="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/">
	<ns2:result xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/" xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/" xmlns:ns3="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" xmlns:ns4="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns1:LocationResult">
		<ns1:Value>
			<ns1:LocationId>300000231257399</ns1:LocationId>
			<ns1:LastUpdateDate>2021-07-22T10:28:39.126Z</ns1:LastUpdateDate>
			<ns1:LastUpdatedBy>LISA.JONES</ns1:LastUpdatedBy>
			<ns1:CreationDate>2021-07-22T10:28:39.001Z</ns1:CreationDate>
			<ns1:CreatedBy>LISA.JONES</ns1:CreatedBy>
			<ns1:LastUpdateLogin>C46AF10F2AFF573BE0534B64F00A91DD</ns1:LastUpdateLogin>
			<ns1:RequestId xsi:nil="true"/>
			<ns1:OrigSystem xsi:nil="true"/>
			<ns1:OrigSystemReference>300000231257399</ns1:OrigSystemReference>
			<ns1:Country>IT</ns1:Country>
			<ns1:Address1>510 Quercia Marcozzi</ns1:Address1>
			<ns1:Address2>Building 300</ns1:Address2>
			<ns1:Address3 xsi:nil="true"/>
			<ns1:Address4 xsi:nil="true"/>
			<ns1:City>Caserta</ns1:City>
			<ns1:PostalCode>90102</ns1:PostalCode>
			<ns1:State>CE</ns1:State>
			<ns1:Province xsi:nil="true"/>
			<ns1:County xsi:nil="true"/>
			<ns1:AddressStyle xsi:nil="true"/>
			<ns1:ValidatedFlag>false</ns1:ValidatedFlag>
			<ns1:AddressLinesPhonetic xsi:nil="true"/>
			<ns1:PostalPlus4Code xsi:nil="true"/>
			<ns1:Position xsi:nil="true"/>
			<ns1:LocationDirections xsi:nil="true"/>
			<ns1:AddressEffectiveDate xsi:nil="true"/>
			<ns1:AddressExpirationDate xsi:nil="true"/>
			<ns1:ClliCode xsi:nil="true"/>
			<ns1:Language xsi:nil="true"/>
			<ns1:ShortDescription xsi:nil="true"/>
			<ns1:Description xsi:nil="true"/>
			<ns1:SalesTaxGeocode xsi:nil="true"/>
			<ns1:SalesTaxInsideCityLimits>1</ns1:SalesTaxInsideCityLimits>
			<ns1:FaLocationId xsi:nil="true"/>
			<ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
			<ns1:CreatedByModule>HZ_CPUI</ns1:CreatedByModule>
			<ns1:GeometryStatusCode>DIRTY</ns1:GeometryStatusCode>
			<ns1:ValidationStatusCode xsi:nil="true"/>
			<ns1:DateValidated xsi:nil="true"/>
			<ns1:DoNotValidateFlag xsi:nil="true"/>
			<ns1:Comments xsi:nil="true"/>
			<ns1:HouseType xsi:nil="true"/>
			<ns1:EffectiveDate>2021-07-22</ns1:EffectiveDate>
			<ns1:AddrElementAttribute1 xsi:nil="true"/>
			<ns1:AddrElementAttribute2 xsi:nil="true"/>
			<ns1:AddrElementAttribute3 xsi:nil="true"/>
			<ns1:AddrElementAttribute4 xsi:nil="true"/>
			<ns1:AddrElementAttribute5 xsi:nil="true"/>
			<ns1:Building xsi:nil="true"/>
			<ns1:FloorNumber xsi:nil="true"/>
			<ns1:StatusFlag>true</ns1:StatusFlag>
			<ns1:InternalFlag>false</ns1:InternalFlag>
			<ns1:TimezoneCode xsi:nil="true"/>
			<ns1:Latitude xsi:nil="true"/>
			<ns1:Longitude xsi:nil="true"/>
			<ns1:Distance xsi:nil="true"/>
		</ns1:Value>
	</ns2:result>
</ns0:createLocationResponse>

Create Location Response with Header.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule//LocationService/createLocationResponse</wsa:Action>
<wsa:MessageID>urn:uuid:06488ee0-757f-433d-a423-3779f2d87e8a</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:createLocationResponse xmlns:ns0="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/">
<ns2:result xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/" xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/" xmlns:ns3="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" xmlns:ns4="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns1:LocationResult">
                  <ns1:Value>
			<ns1:LocationId>300000231257399</ns1:LocationId>
			<ns1:LastUpdateDate>2021-07-22T10:28:39.126Z</ns1:LastUpdateDate>
			<ns1:LastUpdatedBy>LISA.JONES</ns1:LastUpdatedBy>
			<ns1:CreationDate>2021-07-22T10:28:39.001Z</ns1:CreationDate>
			<ns1:CreatedBy>LISA.JONES</ns1:CreatedBy>
			<ns1:LastUpdateLogin>C46AF10F2AFF573BE0534B64F00A91DD</ns1:LastUpdateLogin>
			<ns1:RequestId xsi:nil="true"/>
			<ns1:OrigSystem xsi:nil="true"/>
			<ns1:OrigSystemReference>300000231257399</ns1:OrigSystemReference>
			<ns1:Country>IT</ns1:Country>
			<ns1:Address1>510 Quercia Marcozzi</ns1:Address1>
			<ns1:Address2>Building 300</ns1:Address2>
			<ns1:Address3 xsi:nil="true"/>
			<ns1:Address4 xsi:nil="true"/>
			<ns1:City>Caserta</ns1:City>
			<ns1:PostalCode>90102</ns1:PostalCode>
			<ns1:State>CE</ns1:State>
			<ns1:Province xsi:nil="true"/>
			<ns1:County xsi:nil="true"/>
			<ns1:AddressStyle xsi:nil="true"/>
			<ns1:ValidatedFlag>false</ns1:ValidatedFlag>
			<ns1:AddressLinesPhonetic xsi:nil="true"/>
			<ns1:PostalPlus4Code xsi:nil="true"/>
			<ns1:Position xsi:nil="true"/>
			<ns1:LocationDirections xsi:nil="true"/>
			<ns1:AddressEffectiveDate xsi:nil="true"/>
			<ns1:AddressExpirationDate xsi:nil="true"/>
			<ns1:ClliCode xsi:nil="true"/>
			<ns1:Language xsi:nil="true"/>
			<ns1:ShortDescription xsi:nil="true"/>
			<ns1:Description xsi:nil="true"/>
			<ns1:SalesTaxGeocode xsi:nil="true"/>
			<ns1:SalesTaxInsideCityLimits>1</ns1:SalesTaxInsideCityLimits>
			<ns1:FaLocationId xsi:nil="true"/>
			<ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
			<ns1:CreatedByModule>HZ_CPUI</ns1:CreatedByModule>
			<ns1:GeometryStatusCode>DIRTY</ns1:GeometryStatusCode>
			<ns1:ValidationStatusCode xsi:nil="true"/>
			<ns1:DateValidated xsi:nil="true"/>
			<ns1:DoNotValidateFlag xsi:nil="true"/>
			<ns1:Comments xsi:nil="true"/>
			<ns1:HouseType xsi:nil="true"/>
			<ns1:EffectiveDate>2021-07-22</ns1:EffectiveDate>
			<ns1:AddrElementAttribute1 xsi:nil="true"/>
			<ns1:AddrElementAttribute2 xsi:nil="true"/>
			<ns1:AddrElementAttribute3 xsi:nil="true"/>
			<ns1:AddrElementAttribute4 xsi:nil="true"/>
			<ns1:AddrElementAttribute5 xsi:nil="true"/>
			<ns1:Building xsi:nil="true"/>
			<ns1:FloorNumber xsi:nil="true"/>
			<ns1:StatusFlag>true</ns1:StatusFlag>
			<ns1:InternalFlag>false</ns1:InternalFlag>
			<ns1:TimezoneCode xsi:nil="true"/>
			<ns1:Latitude xsi:nil="true"/>
			<ns1:Longitude xsi:nil="true"/>
			<ns1:Distance xsi:nil="true"/>
		</ns1:Value>
	</ns2:result>
</ns0:createLocationResponse>
</env:Body>
</env:Envelope>

Below is the response without Header for QUERY operation :

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<ns0:findLocationResponse xmlns:ns0="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/">
	<ns2:result xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/" xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/" xmlns:ns3="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" xmlns:ns4="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns1:LocationResult">
		<ns1:Value>
			<ns1:LocationId>300000231028501</ns1:LocationId>
			<ns1:LastUpdateDate>2021-07-21T05:43:10.264Z</ns1:LastUpdateDate>
			<ns1:LastUpdatedBy>LISA.JONES</ns1:LastUpdatedBy>
			<ns1:CreationDate>2021-07-21T05:43:10.001Z</ns1:CreationDate>
			<ns1:CreatedBy>LISA.JONES</ns1:CreatedBy>
			<ns1:LastUpdateLogin>C46AEE319D0C5729E0534B64F00A6EBB</ns1:LastUpdateLogin>
			<ns1:RequestId xsi:nil="true"/>
			<ns1:OrigSystem xsi:nil="true"/>
			<ns1:OrigSystemReference>300000231028501</ns1:OrigSystemReference>
			<ns1:Country>IT</ns1:Country>
			<ns1:Address1>510 Quercia Marcozzi</ns1:Address1>
			<ns1:Address2>Building 300</ns1:Address2>
			<ns1:Address3 xsi:nil="true"/>
			<ns1:Address4 xsi:nil="true"/>
			<ns1:City>Caserta</ns1:City>
			<ns1:PostalCode>90102</ns1:PostalCode>
			<ns1:State>CE</ns1:State>
			<ns1:Province xsi:nil="true"/>
			<ns1:County xsi:nil="true"/>
			<ns1:AddressStyle xsi:nil="true"/>
			<ns1:ValidatedFlag>false</ns1:ValidatedFlag>
			<ns1:AddressLinesPhonetic xsi:nil="true"/>
			<ns1:PostalPlus4Code xsi:nil="true"/>
			<ns1:Position xsi:nil="true"/>
			<ns1:LocationDirections xsi:nil="true"/>
			<ns1:AddressEffectiveDate xsi:nil="true"/>
			<ns1:AddressExpirationDate xsi:nil="true"/>
			<ns1:ClliCode xsi:nil="true"/>
			<ns1:Language xsi:nil="true"/>
			<ns1:ShortDescription xsi:nil="true"/>
			<ns1:Description xsi:nil="true"/>
			<ns1:SalesTaxGeocode xsi:nil="true"/>
			<ns1:SalesTaxInsideCityLimits>1</ns1:SalesTaxInsideCityLimits>
			<ns1:FaLocationId xsi:nil="true"/>
			<ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
			<ns1:CreatedByModule>HZ_CPUI</ns1:CreatedByModule>
			<ns1:GeometryStatusCode>DIRTY</ns1:GeometryStatusCode>
			<ns1:ValidationStatusCode xsi:nil="true"/>
			<ns1:DateValidated xsi:nil="true"/>
			<ns1:DoNotValidateFlag xsi:nil="true"/>
			<ns1:Comments xsi:nil="true"/>
			<ns1:HouseType xsi:nil="true"/>
			<ns1:EffectiveDate>2021-08-12</ns1:EffectiveDate>
			<ns1:AddrElementAttribute1 xsi:nil="true"/>
			<ns1:AddrElementAttribute2 xsi:nil="true"/>
			<ns1:AddrElementAttribute3 xsi:nil="true"/>
			<ns1:AddrElementAttribute4 xsi:nil="true"/>
			<ns1:AddrElementAttribute5 xsi:nil="true"/>
			<ns1:Building xsi:nil="true"/>
			<ns1:FloorNumber xsi:nil="true"/>
			<ns1:StatusFlag>true</ns1:StatusFlag>
			<ns1:InternalFlag>false</ns1:InternalFlag>
			<ns1:TimezoneCode xsi:nil="true"/>
			<ns1:Latitude xsi:nil="true"/>
			<ns1:Longitude xsi:nil="true"/>
			<ns1:Distance xsi:nil="true"/>
			<ns1:LocationProfile>
			<ns1:LocationProfileId>300000231028502</ns1:LocationProfileId>
			<ns1:LocationId>300000231028501</ns1:LocationId>
			<ns1:EffectiveStartDate>2021-07-21</ns1:EffectiveStartDate>
			<ns1:EffectiveEndDate>4712-12-31</ns1:EffectiveEndDate>
			<ns1:ValidationSstFlag>true</ns1:ValidationSstFlag>
			<ns1:ValidationStatusCode xsi:nil="true"/>
			<ns1:DateValidated xsi:nil="true"/>
			<ns1:Address1>510 Quercia Marcozzi</ns1:Address1>
			<ns1:Address2>Building 300</ns1:Address2>
			<ns1:Address3 xsi:nil="true"/>
			<ns1:Address4 xsi:nil="true"/>
			<ns1:City>Caserta</ns1:City>
			<ns1:PostalCode>90102</ns1:PostalCode>
			<ns1:County xsi:nil="true"/>
			<ns1:Country>IT</ns1:Country>
			<ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
			<ns1:LastUpdateDate>2021-07-21T05:43:10.647Z</ns1:LastUpdateDate>
			<ns1:LastUpdatedBy>LISA.JONES</ns1:LastUpdatedBy>
			<ns1:LastUpdateLogin>C46AEE319D0C5729E0534B64F00A6EBB</ns1:LastUpdateLogin>
			<ns1:CreationDate>2021-07-21T05:43:10.263Z</ns1:CreationDate>
			<ns1:CreatedBy>LISA.JONES</ns1:CreatedBy>
			<ns1:RequestId xsi:nil="true"/>
			<ns1:State>CE</ns1:State>
			<ns1:Province xsi:nil="true"/>
			<ns1:EffectiveSequence>1</ns1:EffectiveSequence>
			<ns1:EffectiveLatestChange>Y</ns1:EffectiveLatestChange>
			<ns1:AddrElementAttribute1 xsi:nil="true"/>
			<ns1:AddrElementAttribute2 xsi:nil="true"/>
			<ns1:AddrElementAttribute3 xsi:nil="true"/>
			<ns1:AddrElementAttribute4 xsi:nil="true"/>
			<ns1:AddrElementAttribute5 xsi:nil="true"/>
			<ns1:Building xsi:nil="true"/>
			<ns1:FloorNumber xsi:nil="true"/>
			</ns1:LocationProfile>
			<ns1:LocationInformation>
				<ns4:LocationId>300000231028501</ns4:LocationId>
				<ns4:__FLEX_Context xsi:nil="true"/>
				<ns4:__FLEX_Context_DisplayValue xsi:nil="true"/>
				<ns4:_FLEX_NumOfSegments>0</ns4:_FLEX_NumOfSegments>
			</ns1:LocationInformation>
		</ns1:Value>
	</ns2:result>
</ns0:findLocationResponse>

Archiving tab

See the topic Connector operation’s Archiving tab for more information.

Tracking tab

See the topic Connector operation’s Tracking tab for more information.

Caching tab

See the topic Connector operation’s Caching tab for more information.

On this Page