Oracle® Fusion Middleware

Using the Adapter Configuration Wizard

12.2.1.2.0

E77872-02

February 2017

Oracle Fusion Middleware Using the Adapter Configuration Wizard, 12.2.1.2.0

E77872-02

Copyright © 2015, 2017, Oracle and/or its affiliates. All rights reserved.

Primary Author: Mark Kennedy

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Audience

- Related Resources

- Conventions

1 Unsupported Features

- Unsupported Features

2 Configuring Salesforce Properties

- Understanding Salesforce Cloud Constraints

- Configuring Basic Information Properties

- What You Can Do from the Basic Info Page

- What You See on the Basic Info Page

- Configuring Oracle Cloud Adapter Connection and CSF Key Properties

- What You Can Do from the Oracle Cloud Adapter Connection Page

- What You See on the Oracle Cloud Adapter Connection Page

- What You Can Do from the Oracle Cloud Adapter CSF Key Page

- What You See on the Oracle Cloud Adapter CSF Key Page

- Configuring Salesforce Source Outbound Messaging Properties

- What You Can Do from the Salesforce Cloud Source Outbound Messaging Properties Page

- What You See on the Salesforce Cloud Source Outbound Messaging Properties

- Configuring Salesforce Cloud Target Operation Properties

- What You Can Do from the Salesforce Cloud Target Operations Page

- What You See on the Salesforce Target Operations Page

- Configuring Salesforce Cloud Target Header Properties

- What You Can Do from the Salesforce Cloud Target Headers Page

- What You See on the Salesforce Target Headers Page

- Configuring Salesforce Invoke Custom Operations Properties

- What You Can Do from the Salesforce Cloud Invoke Custom Operations Page

- What You See on the Salesforce Cloud Invoke Custom Operations Page

- Reviewing Configuration Values on the Summary Page

- What You Can Do from the Summary Page

- What You See on the Summary Page

- Performing Salesforce Cloud Postconfiguration Tasks

3 Adding the ServiceNow Adapter Connection to an Integration

- Configuring ServiceNow Adapter Trigger Configuration Properties

- What You Can Do from the ServiceNow Adapter Configuration Page

- What You See on the ServiceNow Adapter Configuration Page

- Configuring ServiceNow Adapter Trigger Fields Properties

- What You Can Do from the ServiceNow Adapter Fields Page

- What You See on the ServiceNow Adapter Fields Page

- Configuring ServiceNow Adapter Trigger Conditions Properties

- What You Can Do from the ServiceNow Adapter Conditions Page

- What You See on the ServiceNow Adapter Conditions Page

- Configuring ServiceNow Adapter Trigger Response Properties

- What You Can Do from the ServiceNow Adapter Response Page

- What You See on the ServiceNow Adapter Response Page

- Configuring ServiceNow Adapter Invoke Operations Properties

- What You Can Do from the ServiceNow Adapter Operations Page

- What You See on the ServiceNow Adapter Operations Page

- Configuring ServiceNow Adapter Invoke Extended Query Parameters

- What You Can Do from the ServiceNow Adapter Extended Query Parameters Page

- What You See on the ServiceNow Adapter Extended Query Parameters Page

4 Adding the SuccessFactors Adapter Connection to an Integration

- Configuring SuccessFactors Adapter Invoke Operation Properties

- What You Can Do from the SuccessFactors Adapter Operations Page

- What You See on the SuccessFactors Adapter Operations Page

5 Adding the SAP Ariba Adapter Connection to an Integration

- Configuring SAP Ariba Adapter Invoke Operations Properties

- What You Can Do from the SAP Ariba Adapter Invoke Operations Page

- What You See on the SAP Ariba Adapter Invoke Operations Page

- Reviewing Configuration Values on the Summary Page

- What You Can Do from the Summary Page

- What You See on the Summary Page

- Performing SAP Ariba Adapter Postconfiguration Tasks

Preface

Topics:

Using the Adapter Configuration Wizard describes the pages of the Adapter Configuration Wizard that you are guided through to configure the Salesforce Adapter, SAP Ariba Adapter, ServiceNow Adapter, and SuccessFactors Adapter.

- Audience

- Related Resources

- Conventions

Audience

Using the Adapter Configuration Wizard is intended for users who want to create, deploy, test, and monitor applications that use the Salesforce Adapter, SAP Ariba Adapter, SuccessFactors Adapter, and ServiceNow Adapter.

Related Resources

For more information, see these Oracle resources:

- Administering Oracle SOA Suite and Oracle Business Process Management Suite

- Administering Oracle Service Bus

- Understanding Technology Adapters

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 Unsupported Features

Note the following issue:

Topic

- Unsupported Features

Unsupported Features

The adapter does not support the following features:

- Message recovery in the Error Hospital in Oracle Enterprise Manager Fusion Middleware Control.

- The display of properties in the Properties tab for a reference (outbound) adapter in Oracle Enterprise Manager Fusion Middleware Control (for example, service WSDL URL, CSF key used, and others). These are the reference adapters that you select on the Services and References page.

- Rejected message handling

- The following message encryption and decryption features available when you right-click a cloud adapter in the Exposed Service swimlane or External References swimlane in Oracle JDeveloper:

- Protect Sensitive Data > Encrypt Request Data for cloud adapters in the Exposed Service swimlane.

- Protect Sensitive Data > Decrypt Sensitive Data for cloud adapters in the External References swimlane.

- The policy attachments feature available when you right-click a cloud adapter in the Exposed Service swimlane or External References swimlane in Oracle JDeveloper.

- The localization of WSDL and schemas files. If you are prompted by the Localize Files dialog after completing the Connections page in the Adapter Configuration Wizard, click Cancel.

2 Configuring Salesforce Properties

The Salesforce Adapter enables you to create integrations with a Salesforce application.

The following sections describe the wizard pages that guide you through configuration of the Salesforce adapter as a trigger and invoke in an integration. Postconfiguration tasks are also provided.

Topic

- Understanding Salesforce Cloud Constraints

- Configuring Basic Information Properties

- Configuring Oracle Cloud Adapter Connection and CSF Key Properties

- Configuring Salesforce Source Outbound Messaging Properties

- Configuring Salesforce Target Operations Properties

- Configuring Salesforce Target Headers Properties

- Configuring Salesforce Invoke Custom Operations Properties

- Reviewing Configuration Values on the Summary Page

- Performing Salesforce Cloud Postconfiguration Tasks

Understanding Salesforce Cloud Constraints

You must be aware of the following constraints before configuring the Salesforce Cloud adapter.

- The Salesforce Cloud adapter uses the SalesForceDotCom (SFDC) API for all activities. Therefore, it is subject to any Salesforce API limitations. The limitations are defined in the Salesforce Limits Quick Reference Guide.

- Not all the Push Topic queries are supported by Salesforce. See Supported Push Topic Queries and Unsupported PushTopic Queries.

- Client applications must adhere to Salesforce’s SOAP API support policy and backward compatibility terms. These terms are available at SFDC SOAP API Support Policy.

Configuring Basic Information Properties

You can enter a name and description on the Basic Info page of each source and target adapter in your integration.

Topics

- What You Can Do from the Basic Info Page

- What You See on the Basic Info Page

What You Can Do from the Basic Info Page

You can specify the following values on the Basic Info page. The Basic Info page is the initial wizard page that is displayed whenever you drag an adapter to the trigger (source) or invoke (target) area supported by your adapter.

- Specify a meaningful name.

- Specify a description of the responsibilities.

What You See on the Basic Info Page

The following table describes the key information on the Basic Info page.

Element

Description

What do you want to call your endpoint?

Provide a meaningful name so that others can understand the responsibilities of this connection. You can include English alphabetic characters, numbers, underscores, and dashes in the name. You cannot include the following:

- Blank spaces (for example, My Inbound Connection)

- Special characters (for example,  #;83& or righ(t)now4)

- Multibyte characters

What does this endpoint do?

Enter an optional description of the connection’s responsibilities. For example: This connection receives an inbound request to synchronize account information with the cloud application.

Configuring Oracle Cloud Adapter Connection and CSF Key Properties

Enter the Oracle Cloud adapter configuration connectivity and Credential Store Framework (CSF) key values for your integration.

Topics

- What You Can Do from the Oracle Cloud Adapter Connection Page

- What You See on the Oracle Cloud Adapter Connection Page

- What You Can Do from the Oracle Cloud Adapter CSF Key Page

- What You See on the Oracle Cloud Adapter CSF Key Page

What You Can Do from the Oracle Cloud Adapter Connection Page

You can specify the following connection values for the Oracle Cloud adapter.

- Specify the WSDL URL for some adapters. If you are configuring the Oracle Eloqua Cloud adapter, no WSDL is required.

- Specify the security policy.

- Create the authentication key. A key created for one direction (for example, outbound) is also available for selection in the other direction (for example, inbound).

What You See on the Oracle Cloud Adapter Connection Page

The following table describes the key information on the Oracle Cloud adapter Connection page.

Element

Description

WSDL URL

Note: This field is not displayed for the Oracle Eloqua Cloud adapter.

Specify the WSDL. The WSDL is used to build integrations specific to your instance. You can also select the WSDL from a file system or another source by choosing the browser icon next to the WSDL URL field. Click File System at the top of the dialog, then browse for the WSDL.

Security Policy

Select the security policy appropriate to your environment (for example, USERNAME_PASSWORD_TOKEN).

- The wizard shows all policies, including those that may not be applicable. To make a correct selection, you must have a knowledge of policies. For example, you cannot select a SAML-based policy because the identity is not propagated.

- The policies you apply to the cloud adapter are unique to the cloud adapter and do not impact other endpoints in the composite.

Authentication Key

Select the CSF authentication key.

- Add: Click to create a new authentication key. You must specify the key name, user name, and password.

- Edit: Click to edit an authentication key.

- Delete: Click to delete an authentication key.

Test

Click to validate the authentication key.

What You Can Do from the Oracle Cloud Adapter CSF Key Page

You can specify the following CSF key values for the Oracle Cloud adapter.

- CSF key name

- User name and password

- If you are configuring the Oracle Eloqua Cloud adapter only, you must specify a company name.

What You See on the Oracle Cloud Adapter CSF Key Page

The following table describes the key information on the Oracle Cloud adapter CSF Key page.

Element

Description

CSF Key Name

Specify the CSF key to enable runtime injection of credentials. The adapter uses the CSF to retrieve the username and password required for authentication with the application (for example, the Oracle Sales Cloud or Oracle ERP application). This key identifies your login credentials during design-time.

Company Name (Oracle Eloqua Cloud adapter only)

Note: This field is only displayed for the Oracle Eloqua Cloud adapter.

Specify the Oracle Eloqua company name.

Email Account and Role

Note: This field is only displayed for the Oracle NetSuite Cloud adapter.

Specify the email account and role.

User Name

Enter the user name for connecting to your application (for example, the Oracle Sales Cloud or Oracle ERP application). Your administrator provides you with user credentials.

Password

Enter the password for connecting to your application.

Re-enter Password

Re-enter the same password a second time.

Configuring Salesforce Source Outbound Messaging Properties

Enter the Oracle Salesforce Cloud source outbound messaging values for your integration.

Topics

- What You Can Do from the Salesforce Cloud Source Outbound Messaging Properties Page

- What You See on the Salesforce Cloud Source Outbound Messaging Properties

What You Can Do from the Salesforce Cloud Source Outbound Messaging Properties Page

You can configure the source outbound messaging WSDL for the Salesforce Cloud adapter.

This process consists of several steps:

- The outbound message consists of a workflow, approval, or milestone action that sends your specified information to your specified endpoint. You configure outbound messaging in the Salesforce setup menu. Afterward, you configure the endpoint.

To create a workflow rule:

1. Log in to your Salesforce account and go to Setup.

2. Under the App Setup menu, expand Create, followed by Workflow & Approvals.

3. Select a workflow rule or approval process as per your integration requirement.

4. Click Create New, provide the required information in the following wizards, and click Save.

a. For the workflow rule, click Edit under the Workflow Action menu followed by Add Workflow Action, and then New Outbound Message.

b. For the approval process, click Add New (you can select for one or more actions including Submission, Approval, Rejection, and Recall) followed by New Outbound Message.

Outbound messaging WSDLs associated with approval processes or entitlement processes are also supported and consumed by the adapter.

- Generate the Salesforce outbound messaging WSDL at www.salesforce.com, then select the target outbound messaging WSDL you created to receive outbound message notifications from the Salesforce application. For instructions, see What You See on the Salesforce Cloud Source Outbound Messaging Properties.

What You See on the Salesforce Cloud Source Outbound Messaging Properties

The following table describes the key information on the source Outbound Messaging page.

Element

Description

Select the Outbound Messaging WSDL

Generate and then select the target Salesforce outbound messaging WSDL to receive outbound message notifications from the Salesforce application.

Note: You must first create a workflow rule as described in What You Can Do from the Salesforce Cloud Source Outbound Messaging Properties Page. Outbound messaging WSDLs associated with approval processes or entitlement processes are also supported and consumed by the adapter.

To generate and then select the target Salesforce outbound messaging WSDL:

1. Log in to your Salesforce account and go to Setup > Outbound Messages.

2. Select the required object, and click Next.

3. Enter other required details (in the Endpoint URL field, enter a dummy URL), and click Save.

4. Click Generate WSDL to download the WSDL.

5. Return to this wizard page and browse for the generated WSDL.

6. Activate the integration and copy the endpoint URL from the integration information icon.

7. Go to the Outbound Messaging section at www.salesforce.com and replace the dummy URL you entered in Step 3 with the real endpoint URL.

Configuring Salesforce Cloud Target Operation Properties

Enter the Salesforce Cloud target operation values for your integration.

Topics

- What You Can Do from the Salesforce Target Operations Page

- What You See on the Salesforce Target Operation Page

What You Can Do from the Salesforce Cloud Target Operations Page

You can configure the following target operations values for Salesforce Cloud.

- Select either of the following operation types:

1. CRUD

2. Salesforce Object Query Language (SOQL) or Salesforce Object Search Language (SOSL) query

- Select the business objects.

- Specify the SOQL/SOSL query.

What You See on the Salesforce Target Operations Page

The following table describes the key information on the Salesforce Cloud target Operations page.

Element

Description

Select an Operation Type

Select the type of operation to perform:

- CORE : Represents all core operations supported by the Salesforce application.

- CRUD: Represents the create, read, update, delete, or destroy operation to perform on Salesforce business objects. Each letter maps to a standard SQL statement, HTTP method, or DDS operation. Select the CRUD operation to perform: Create, Delete, Retrieve, or Update.

- MISC: Represents specialized task operations (such as fetching user information associated with the current session) in the Salesforce application.

- SOSL/SOQL: Select to enter a Salesforce Object Query Language (SOQL) or Salesforce Object Search Language (SOSL) query to send as a request to the Salesforce application. The following operations are available:

- query: Executes a query against specific criteria and returns data matching that criteria. Only records not deleted from your Salesforce application account are returned.

- queryAll: Returns the same data as the query operation, along with deleted records present in the recycle bin.

- search: Returns records from the Salesforce application. You can specify binding parameters to dynamically provide a search string as input to your search operation.

If you select this option, the page is refreshed to display a field for entering an SOQL or SOSL query to send for validation:

- Query Statement: Enter a valid query statement. SOQL statements evaluate to a list of sObjects, a single sObject, or an integer for count method queries. The following examples are provided:

“SELECT Id FROM Contact WHERE Name LIKE 'A%' AND MailingCity = 'California'”

SELECT COUNT() FROM Contact

SOSL statements evaluate to a list of sObjects, where each list contains the search results for a particular sObject type. For example:

“SELECT a.name, a.id, a.accountNumber, c.name from Contact c, c.Account”

- Binding Parameters: Displays any parameters included in the query. For example, orgId is a parameter in the following query:

SELECT a.name, a.id, a.accountNumber, c.name from Contact c, c.Account a WHERE a.name = "&orgId"

This query displays a binding parameters text box in which to enter a test value for orgId.

- Test My Query. Click to validate the query against the Salesforce application. Query results are displayed. If errors occur, you receive results about how to correct the query.

Filter By Object Name

Type the initial letters to filter the display of business objects. You can also select a filter type:

- All: Displays all objects.

- Custom: Displays objects you created. Custom business objects are appended with “_c.”

- Standard: Business objects delivered as part of the Salesforce application.

Select Business Objects

Select a single or multiple business objects to include in the operation. You can select up to ten objects for one operation.

Configuring Salesforce Cloud Target Header Properties

Enter the Salesforce Cloud target header values for your integration.

Topics

- What You Can Do from the Salesforce Target Headers Page

- What You See on the Salesforce Target Headers Page

What You Can Do from the Salesforce Cloud Target Headers Page

You can configure the target header properties for Salesforce Cloud.

What You See on the Salesforce Target Headers Page

The following table describes the key information on the Salesforce Cloud target Headers page.

The headers available for configuration are based on the operation you selected on the target Operations page. There are two types of headers:

- Request headers are sent with the request message to the Salesforce application.

- Response headers are received with the response message sent from the Salesforce application.

For more information about these header properties, visit www.salesforce.com and specify the specific name of the property in the search utility.

Element

Description

AllOrNoneHeader (request header)

Specifies the transactional behavior for Salesforce application operations. If you set AllorNone to true, the call to the Salesforce application is committed only if it completes without any errors. Otherwise, it is rolled back. The default behavior is to commit partial records without any error.

AllowFieldTruncationHeader (request header)

Specifies the truncation behavior for the following fields (each are string data types):

- anyType

- email

- picklist

- encryptedstring

- textarea

- mulitpicklist

- phone

- string

Set allowFieldTruncation to one of the following values:

- True: If you enter a value of 25 characters in a field of 20 characters, the first 20 records are inserted into the field and the transaction is successful.

- False: If you enter a value of 25 characters in a field of 20 characters, an error is thrown and the transaction does not commit.

AssignmentRuleHeader (request header)

Specifies the assignment rule to use when creating or updating an account, case, or lead. The assignment rule can be active or inactive. The ID is retrieved by querying the AssignmentRule object. If the ID is specified, you do not need to specify the useDefaultRule value.

- assignmentRuleId: The ID of the assignment rule to use. The ID is not validated by the Salesforce Cloud application, whether or not it exists. Validation occurs during runtime.

- useDefaultRule: If set to true, the default (active) assignment rule is used. If set to false, the default (active) assignment rule is not used.

EmailHeader (request header)

Specifies whether or not to send a notification email. You can set the following properties:

- triggerAutoResponseEmail

- true: Triggers automatic response rules for leads and cases.

- false: Automatic response rules for leads and cases are not triggered.

- triggerOtherEmail

- true: The email is triggered outside the organization.

- false: The email is not triggered outside the organization.

- triggerUserEmail

- true: The email is triggered and sent to users in the organization. This email is triggered by a number of events such as adding comments to a case or updating a task.

- false: The email is not triggered and sent to users in the organization.

DebuggingHeader (request header)

Specify the debugging log level. The following log levels are supported:

- NONE (least verbose)

- DEBUGONLY

- DB

- PROFILING

- CALLOUT

- DETAIL (most verbose)

MruHeader (request header)

The Salesforce application shows the most recently used (MRU) items. In API version 7.0 or later, the list is not updated by itself. Use MruHeader to update the list. Using this header can negatively impact performance. Set updateMru to one of the following values:

- true: The list of MRU items is updated in the Salesforce application.

- false: The list of most recently used items is not updated in the Salesforce application.

PackageVersionHeader (request header)

Specifies the package version for any installed package. The package version identifies the components in a package. The package version follows the format majorNumber.minorNumber.patchNumber (for example, 3.4.5, where 3 refers to majorNumber, 4 refers to minorNumber, and 5 refers to patchNumber) .

QueryOptions (request header)

Specifies the batch size for queries. The default value is 500, the minimum value is 200, and the maximum value is 2000.

DebuggingInfo (response header)

This information is only returned if the debugLevel request header is sent with the request payload to the Salesforce application.

LimitInfoHeader (response header)

Provides information about the limitations of API calls on a per-day basis for the organization.

- current: The number of calls already used in the organization.

- Limit: The organization’s limit for the specified limit type.

- Type: The limit information type specified in the header API REQUESTS (contains limit information about API calls for the organization).

Configuring Salesforce Invoke Custom Operations Properties

Specify the following values on the Salesforce invoke Custom Operations page.

Topics

- What You Can Do from the Salesforce Cloud Invoke Custom Operations Page

- What You See on the Salesforce Cloud Invoke Custom Operations Page

What You Can Do from the Salesforce Cloud Invoke Custom Operations Page

You can specify the following values on the Salesforce Cloud invoke Custom Operations page.

- Select the custom WSDL.

- Select the operations to perform.

- Optionally select a new custom WSDL to use.

What You See on the Salesforce Cloud Invoke Custom Operations Page

The following table describes the key information on the Salesforce Cloud invoke Custom Operations page.

Element

Description

Select the Custom WSDL

Select the custom WSDL to use.

Operations in Uploaded WSDL

Displays the list of operations included in the uploaded custom WSDL. Select the operation to perform in the Salesforce Cloud application.

Select New Custom WSDL

Click Choose File to select the custom WSDL to use. This selection replaces any previously uploaded WSDL file. After selecting the new WSDL, return to the Operations in Uploaded WSDL list and select the new operation to use.

To use a custom WSDL that includes custom Apex classes written on force.com and exposed as SOAP web services, see Exposing Apex Methods as SOAP Web Services.

Reviewing Configuration Values on the Summary Page

You can review the specified adapter configuration values on the Summary page.

Topics

- What You Can Do from the Summary Page

- What You See on the Summary Page

What You Can Do from the Summary Page

You can review source or target configuration details from the Summary page. The Summary page is the final wizard page for each adapter after you have completed your configuration.

- View the configuration details you defined for the source or target adapter. For example, if you have defined an inbound source adapter with a request business object and immediate response business object, specific details about this configuration are displayed on the Summary page.

- Click Done if you want to save your configuration details.

- Click a specific tab in the left panel or click Back to access a specific page to update your configuration definitions.

- Click Cancel to cancel your configuration details.

What You See on the Summary Page

The following table describes the key information on the Summary page.

Element

Description

Summary

Displays a summary of the source or target configuration values you defined on previous pages of the wizard.

For adapters for which a generated XSD file is provided, click the XSD link to view a read-only version of the file.

To return to a previous page to update any values, click the appropriate tab in the left panel or click Back.

Performing Salesforce Cloud Postconfiguration Tasks

After activating your integration, you must update the outbound message for the Salesforce Cloud adapter to send messages to Oracle Integration Cloud Service. This section describes how to activate a workflow rule.

1. Open the Salesforce application.

2. Scroll down and click Workflow Rules.

3. In the Workflow Rules panel, click the workflow rule.

4. Scroll down to the Immediate Workflow Actions section and click the outbound message.

5. In the Outbound Message panel, click Edit.

6. In the Edit Outbound Message panel, enter the endpoint URL from the Integration Details icon for the integration.

7. In the Edit Outbound Message panel, click Save.
The Outbound Message panel is displayed.

8. In the Outbound Message panel, scroll down and find the Workflow Rules Using This Outbound Message section.

9. Click the workflow link.
The Workflow Rule panel is displayed.

10. In the Workflow Rule panel, click Activate.
Your workflow is activated. The Salesforce application starts sending messages to the integration endpoint URL created when you activated the integration.

3 Adding the ServiceNow Adapter Connection to an Integration

The ServiceNow Adapter enables you to create integrations with a ServiceNow Cloud application.

The following sections describe the wizard pages that guide you through configuration of the ServiceNow Adapter as both a trigger and invoke connection in an integration.

Topic

- Configuring Basic Information Properties

- Configuring ServiceNow Adapter Trigger Configuration Properties

- Configuring ServiceNow Adapter Trigger Fields Properties

- Configuring ServiceNow Adapter Trigger Conditions Properties Configuring ServiceNow Adapter Trigger Response Properties

- Configuring ServiceNow Adapter Invoke Operations Properties

- Configuring ServiceNow Adapter Invoke Extended Query Parameters

- Reviewing Configuration Values on the Summary Page

Configuring ServiceNow Adapter Trigger Configuration Properties

Select the application and module for which you want to received notifications.

Topics

- What You Can Do from the ServiceNow Adapter Configuration Page

- What You See on the ServiceNow Adapter Configuration Page

What You Can Do from the ServiceNow Adapter Configuration Page

Use the configuration page to select an application and module for which you want receive notifications.

What You See on the ServiceNow Adapter Configuration Page

The following table describes the key information on the ServiceNow Adapter Configuration page.

Element

Description

Select ServiceNow Application

Use the scrolling list to select an application for which you want to receive notifications when it is inserted, updated, or deleted.

Filter By Application Name

Type the initial letters of the application name to filter the display of names in the list.

Select ServiceNow Module

Use the scrolling list to select a module from the application you previously selected.

Filter By Module Name

Type the initial letters of the module name to filter the display of names in the list.

Configuring ServiceNow Adapter Trigger Fields Properties

Enter the ServiceNow Adapter trigger format definition parameters.

Topics

- What You Can Do from the ServiceNow Adapter Fields Page

- What You See on the ServiceNow Adapter Fields Page

What You Can Do from the ServiceNow Adapter Fields Page

Use the Fields page to specify the fields for which you want notification when they are inserted, updated, or deleted.

What You See on the ServiceNow Adapter Fields Page

The following table describes the key information on the ServiceNow Adapter Fields page.

Element

Description

Type field name to filter

Type the initial letters of the field name to filter the display of names in the list. Use the dropdown menu to narrow or widen the list of fields:

- ALL — Shows all of the available fields

- CUSTOM — Shows only the custom fields

- STANDARD — Shows only the standard fields

Available Fields

Use the scrolling list to select a list of fields for which you want to receive notifications when it is inserted, updated, or deleted. These are fields contained in the application and module you selected on the Configurations page. The fields are moved to the Selected Fields list as you select them.

You can double-click on a field name or use the arrow buttons to move the field to the Selected Fields list.

Selected Fields

The list of fields you have selected.

Configuring ServiceNow Adapter Trigger Conditions Properties

Use this page to select actions that trigger a notification when they are performed on the selected fields. You can also set condition statements that govern the conditions under which the notifications are triggered.

Topics

- What You Can Do from the ServiceNow Adapter Conditions Page

- What You See on the ServiceNow Adapter Conditions Page

What You Can Do from the ServiceNow Adapter Conditions Page

You can use the ServiceNow Adapter Conditions page to create complex condition statements to notify you when a selected fields are inserted, updated or deleted.

What You See on the ServiceNow Adapter Conditions Page

The following table describes the key information on the ServiceNow Adapter Conditions page.

Element

Description

Receive notifications when asset gets:

- Inserted

- Updated

- Deleted

Select one or more of the listed events (inserted, updated, deleted) that will trigger a notification when it is performed on the selected application, module or field.

Enter field conditions

Use this part of the page to construct statements that govern the conditions under which the notifications are triggered. Click the checkbox to activate the condition control.

Configuring ServiceNow Adapter Trigger Response Properties

Use the ServiceNow Adapter Response page to configure a callback response in the case of either a successful or failed integration flow.

Topics

- What You Can Do from the ServiceNow Adapter Response Page

- What You See on the ServiceNow Adapter Response Page

What You Can Do from the ServiceNow Adapter Response Page

You can use the Response page to do one of the following:

- Elect to send a response or not to send a response.

- Send a response if the integration flow completes successfully.

- Send a response if the integration flow fails.

What You See on the ServiceNow Adapter Response Page

The following table describes the key information on the ServiceNow Adapter Response page.

Element

Description

Send response

Click the Send Response checkbox to reveal the Successful response and Failed response tabs.

Successful response

Click the Send successful response checkbox to activate the Select ServiceNow Application and Select ServiceNow Module scrolling lists. Select the application and module to configure for a successful callback response.

Use the Filter By ... fields to filter the display of names in the list.

Failed response

Click the Send failed response checkbox to activate the Select ServiceNow Application and Select ServiceNow Module scrolling lists. Select the application and module to configure for a failed callback response.

Use the Filter By ... fields to filter the display of names in the list.

Configuring ServiceNow Adapter Invoke Operations Properties

Configure the operation to perform in the invoke ServiceNow Adapter application.

Topics

- What You Can Do from the ServiceNow Adapter Operations Page

- What You See on the ServiceNow Adapter Operations Page

What You Can Do from the ServiceNow Adapter Operations Page

Select an application and module on which to perform an operation. Then select the operation to perform in the application.

What You See on the ServiceNow Adapter Operations Page

The following table describes the key information on the ServiceNow Adapter Operations page.

Element

Description

Select ServiceNow Application

Use the scrolling list to select a module from the application you previously selected.

Filter By Application Name

Type the initial letters of the application name to filter the display of names in the list.

Select ServiceNow Module

Use the scrolling list to select a module from the application you previously selected.

Filter By Module Name

Type the initial letters of the module name to filter the display of names in the list.

Select an Operation

Select one of the following operations to perform in the ServiceNow application from the dropdown menu:

- Aggregate — Query a table using an aggregate function like SUM, COUNT, MIN, MAX, AVG

- Delete — Delete one or more record from the selected table.

- Get — Query the selected table by example values and return the matching records and their fields.

- Insert — Create a new record for the selected table

- Update — Update an existing record in the selected table, identified by the mandatory sys_id field.

Get keys (Displayed only if the Get operation is selected)

If this checkbox is checked, the Get operation returns all matching records and their fields.

Extended Query Parameters (Displayed only if the Get operation is selected)

Invokes the Extended Query Parameters page. Use this page to configure event criteria and extended query parameters used to filter the returned results. See Configuring ServiceNow Adapter Invoke Extended Query Parameters for a description.

Test Get Operation (Displayed only if the Get operation is selected)

Test Get Operation is enabled when the user selects the Get operation. Enables you to test the operation based on the parameters you selected.

Configuring ServiceNow Adapter Invoke Extended Query Parameters

Enter the ServiceNow Adapter invoke connection extended query parameter values for your integration.

Note:
This page is invoked by clicking the Extended Query Parameters button on the Operations page.

Topics

- What You Can Do from the ServiceNow Adapter Extended Query Parameters Page

- What You See on the ServiceNow Adapter Extended Query Parameters Page

What You Can Do from the ServiceNow Adapter Extended Query Parameters Page

You can specify the following values on the ServiceNow Adapter Extended Query Parameters page.

- Specify the extended query parameters.

- Select the fields to include in the query.

What You See on the ServiceNow Adapter Extended Query Parameters Page

The following table describes the key information on the ServiceNow Adapter Extended Query Parameters page. For example, if you selected Incident as the table in which to query records and GET as the operation to perform on the table in ServiceNow, you may select a number from the Order by dropdown list in the Extended Query Parameters section and select short_description in the Include Fields section.

Element

Description

Extended Query Parameter

Select the extended query parameters to use from the following list:

- Order By — Uses the specified field to order the returned results.

- Order By desc — Uses the specified field to order the returned results in descending order.

- First row — Offsets the results by this number of records from the beginning of the set. When used with Last row, it has the effect of querying for a window of results. The results include the first row number.

- Last row — Limits the results by this number of records from the beginning of the set or the start row values when specified. When used with First row, it has the effect of querying for a window of results. Returns fewer results than the last row number and does not include the last row.

- Limit — Limits the number of records returned.

- Use view — Specifies the name of a form view that is used to limit and expand the returned results. When the form view contains deeply referenced fields (for example, caller_id.email), this field is also returned in the result.

Include Fields

Select the fields to include.

Filter By Field Name

Type the initial letters of the field name to filter the display of names in the list.

Select Fields to include

Displays the fields available to select from the application.

Included Fields

Displays the selected fields.

Encoded query

Build a custom query. For example:

Incident number is INC0022759 and Active is true

4 Adding the SuccessFactors Adapter Connection to an Integration

When you drag the SuccessFactors Adapter into the invoke area of an integration, the Adapter Endpoint Configuration Wizard appears. This wizard guides you through configuration of SuccessFactors Adapter endpoint properties.

The following sections describe the wizard pages that guide you through configuration of the SuccessFactors Adapter as an invoke connection in an integration. The SuccessFactors Adapter cannot be used as a trigger connection in an integration.

Topics

- Configuring Basic Information Properties

- Configuring SuccessFactors Adapter Invoke Operation Properties

- Reviewing Configuration Values on the Summary Page

Configuring SuccessFactors Adapter Invoke Operation Properties

Enter the SuccessFactors Adapter invoke operation values for your integration.

Topics

- What You Can Do from the SuccessFactors Adapter Operations Page

- What You See on the SuccessFactors Adapter Operations Page

What You Can Do from the SuccessFactors Adapter Operations Page

You can specify the following values on the Operations page.

- Select an operation type.

- Select the business object on which to perform the operation.

What You See on the SuccessFactors Adapter Operations Page

The following table describes the key information on the SuccessFactors Adapter Operations page.

Element

Description

Select an Operation Type

Select the type of operation to perform on the business objects in an Oracle SuccessFactors application:

- CRUD: Displays the insert, upsert, update, and delete operations to perform on SuccessFactors business objects. Select the operation and the business object on which to perform the operation.

- SFQL: (SuccessFactors Query Language) enables you to define an SFQL-based query to send a request for querying a particular business object and retrieve the respective object’s information, which is queried from the SuccessFactors application. If you select this option, the page is refreshed to display a text box for entering a query.

- SFQL query statement: Enter a valid SFQL query in the text box. The query can include custom fields and parameters. For example:

SELECT guid,name FROM Goal$7 WHERE userid = ‘USR-22'

Use the Find field to search for an entry in the SFQL query and the Go to Line field to go to a specific line in the SFQL query.

The query can include custom fields and parameters.

- Binding Parameters: Displays any binding parameter, if included, in the specified query. For example, ‘firstname’ is a parameter in the following query:

SELECT firstname,lastname FROM user WHERE firstname = ‘&firstname’
Enter a query with a parameter and press the Refresh button above Binding Parameters. A text box in which to enter a test value for the parameter is displayed.

- Test My Query: Click to validate the query against the SuccessFactors application. The query response is displayed for a successful query. If the query is invalid, you receive a response for the errors in the query.

Filter by object name

Enter the initial letters of an object name to display a range of objects. You can also select a filter type:

- All: Displays all objects available for the selected operation.

- Custom: Displays objects that can be created in the SuccessFactors application for the selected operation. These business objects are identified by special icon (‘-’). For example, Goal-1, DevelopmentGoal-2002.

- Standard: Displays business objects delivered as part of the SuccessFactors application.

Select Business Objects (sfapiv1 API)

Select a business object from the SuccessFactors application (multiple objects are not supported). The selected operation acts on this business object. The SuccessFactors API version that is displayed is based on the SuccessFactors Cloud application version to which you are connected.

Your Selected Business Objects

Displays the selected business objects.

What is this Object

Describes the selected business object.

5 Adding the SAP Ariba Adapter Connection to an Integration

When you drag the SAP Ariba Adapter onto the invoke area of an integration canvas, the Adapter Endpoint Configuration Wizard appears. This wizard guides you through configuration of the SAP Ariba Adapter endpoint properties.

The following sections describe the wizard pages that guide you through configuration of the SAP Ariba Adapter as an invoke in an integration.

Topics

- Configuring Basic Information Properties

- Configuring SAP Ariba Adapter Invoke Operations Properties

- Reviewing Configuration Values on the Summary Page

- Performing SAP Ariba Adapter Postconfiguration Tasks

Configuring SAP Ariba Adapter Invoke Operations Properties

Enter the SAP Ariba Adapter invoke operation values for your integration.

Topics

- What You Can Do from the SAP Ariba Adapter Invoke Operations Page

- What You See on the SAP Ariba Adapter Invoke Operations Page

What You Can Do from the SAP Ariba Adapter Invoke Operations Page

You identify the operation to perform in the SAP Ariba application.

What You See on the SAP Ariba Adapter Invoke Operations Page

The following table describes the key information on the SAP Ariba Adapter Operations page.

Element

Description

Ariba Solution

Identifies the SAP Ariba application type on which the operation is executed.

Operations

Selects the API operation to perform. These are the available operations:

- Import Contract Workspace — Imports contract workspace information from an external application into the SAP Ariba application.

- Create Suppliers — Imports supplier information from an external application into SAP Ariba.

- Create Event — Imports event information from an external application into SAP Ariba.

- Create External Request For Approval — Imports external requests for approval from an external application into SAP Ariba.

- Create Remittance — Returns the amount paid to suppliers for each invoice. Select this operation when remittance information is imported from an ERP application directly into SAP Ariba.

- Create Sourcing Project — Creates a sourcing project.

- Create Organizations — Creates an organization.

- Create External Contract Information — Returns contract information from external applications.

- Create Procurement Unit — Imports procurement unit information from an external application into SAP Ariba.

- Create Requisitions — Imports requisition information from an external application into SAP Ariba.

- Catalog Item Search — Searches for catalog items in SAP Ariba to allow the synchronization of operations between SAP Ariba and external applications.

Description

A description of the selected API operation.

Reviewing Configuration Values on the Summary Page

You can review the specified adapter configuration values on the Summary page.

Topics

- What You Can Do from the Summary Page

- What You See on the Summary Page

What You Can Do from the Summary Page

You can review trigger (source) or invoke (target) configuration details from the Summary page. The Summary page is the final wizard page for each adapter after you have completed your configuration.

- View the configuration details you defined for the trigger (source) or invoke (target) adapter. For example, if you have defined an inbound trigger (source) adapter with a request business object and immediate response business object, specific details about this configuration are displayed on the Summary page.

- View next steps for completing the integration.

- Click Next Steps to hide the Next Steps information.

- Click Done if you want to save your configuration details.

- Click a specific tab in the left panel or click Back to access a specific page to update your configuration definitions.

- Click Cancel to cancel your configuration details.

What You See on the Summary Page

The following table describes the key information on the Summary page.

Element

Description

Summary

Displays a summary of the trigger (source) or invoke (target) configuration values you defined on previous pages of the wizard.

The information that is displayed can vary by adapter. For some adapters, the selected business objects and operation name are displayed. For adapters for which a generated XSD file is provided, click the XSD link to view a read-only version of the file.

To return to a previous page to update any values, click the appropriate tab in the left panel or click Back.

To hide the next steps information, click Next Steps.

Performing SAP Ariba Adapter Postconfiguration Tasks

Complete these postconfiguration tasks after you have configured the invoke connection, mapped the data and tracking fields, and activated the integration.

- Complete these procedures in the SAP Ariba Administration and Data Maintenance Fundamentals Guide: Collecting Access and Security Information, Configuring an End Point, Configuring an Integration Task for Web Services, and Enabling and Disabling Configured Integration Tasks. The Administration and Data Maintenance Fundamentals Guide is available at https://connect.ariba.com/AC. An SAP Ariba user account is required to access the documentation.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2018, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.