1. Using the Oracle Service Cloud (RightNow) Adapter with Oracle Integration Generation 2
  2. Add the Oracle Service Cloud (RightNow) Adapter Connection to an Integration
  3. Invoke Operation Page

Invoke Operation Page

Enter the Oracle Service Cloud (RightNow) invoke operation values for your integration.

Element Description

Select an Operation Mode

Select the operation mode in which to define business objects:

  • Single Operation: Select to configure a single operation.

  • Batch Operation: Select to configure multiple operations in a batch. This enables you to run multiple operations in a defined sequence.

    Selecting this option refreshes the page to display an option for the following:

    • Click to add an operation to the List: Click to create a list of batch operations and their business objects. The operations are performed in the order in which they appear in the list (from top to bottom). When complete, click OK.

    When you complete invoke Oracle Service Cloud (RightNow) Adapter configuration and click Next to access the Summary page, you can perform the following batch operation tasks:

    • Edit icon: Click to edit an operations row in the table or change the order of batch operations.

    • Delete icon: Click to delete a selected operation row in the table.

Select an Operation Type

Select the type of operation to perform on the business objects in an Oracle Service Cloud (RightNow) application:

Note: You can select CRUD business operations or query objects such as QueryCSV (tabular query) or QueryObjects. However, if you want to access other operations exposed by Oracle Service Cloud (RightNow) such as GetFileData, use the SOAP Adapter or REST Adapter.

  • CRUD: Represents the create, read, update, delete, or destroy operations to perform on Oracle Service Cloud (RightNow) business objects. Each letter maps to a standard SQL statement, HTTP method, or DDS operation. Select the CRUD operation to perform on the business object: Create, Destroy, Get, or Update.

    If you select Create or Update, you can select a business object that supports file attachments. This enables you to upload files to Oracle Service Cloud (RightNow).

  • File Attachment: Select to download a file as an attachment from Oracle Service Cloud (RightNow) to Oracle Integration. After selecting File Attachment, you are prompted to select the business object from which to download the file attachment in the Select a Business Object you would like to download the attachment from table. After the file is downloaded, the Oracle Service Cloud (RightNow) Adapter exposes the file reference in the mapper for use by other adapters for further processing.

  • ROQL: (RightNow Object Query Language) enables you to define an ROQL-based query to send as a request to perform in the Oracle Service Cloud (RightNow) application. If you select this option, the page is refreshed to display a field for entering a query.

    • ROQL query statement: Enter a valid ROQL query in the field. For example: 

      SELECT contacts FROM organization WHERE name = 'RightNow'

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

      The query can include custom fields and parameters.

    • Parameter Bindings: Displays any parameter bindings included in the specified query. For example, orgId is a parameter in the following query: 
      SELECT Organization FROM Organization WHERE id = &orgId
      Enter a query with a parameter and click the Refresh icon to the right of Parameter Bindings. This displays a text box in which to enter a test value for the parameter.
    • Page Size: Optionally enter a value to limit the number of objects returned in a query response. An ROQL query with an unbounded where condition can result in increased application memory load and may lead to overall system slowness. This field is only displayed if you selected the QueryObjects operation.

    • Test My Query: Click to fully validate the query against the Oracle Service Cloud (RightNow) application. Query results are displayed. If errors occur, you receive results about how to correct the query.

      If you do not fully validate your query by pressing this button, it is still validated when you press Next, but with potential limitations based on how the query is written. See Write Fully-Validated ROQL Query Statements.

    See Specify QueryCSV Statements When Configuring the Oracle Service Cloud (RightNow) Adapter as an Invoke.

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.

  • Custom: Displays objects you created. These business objects are identified by special icons. The naming convention is a combination of the package name and object name joined by a '.'. For example, if there is a custom object package called CO and an object named PurchaseProduct, the wizard displays the custom object as CO.PurchaseProduct.

  • Standard: Displays business objects delivered as part of the Oracle Service Cloud (RightNow) application.

Select Business Objects (Service Now Version API)

Select a single business object or multiple business objects from the Oracle Service Cloud (RightNow) application. The selected operation acts upon these business objects. The Oracle Service Cloud (RightNow) API version that is displayed is based on the Oracle Service Cloud (RightNow) application version to which you are connected.

When you complete invoke operation configuration, the selected operation and business objects are defined in the integration-centric WSDL file.

Your Selected Business Objects

Displays the selected business objects.

Processing Options

Select to enable aspects of server-side processing. By default, no options are selected. When complete, click OK.

  • Suppress External Events: Select to prevent the Oracle Service Cloud (RightNow) application from processing any external events raised after the completion of create, update, or delete operations.

  • Suppress Rules: Select to prevent business rules from running after the completion of create, update, or delete operations. Business rules are tools for simplifying and automating common business tasks. See the Oracle Service Cloud (RightNow) documentation for more information.

  • Suppress Response: Select to prevent the CRUD Create operation from returning a response ID. If this check box is disabled, the Create operation returns an ID of the created object.

  • Commit After: Select to group multiple operations in a single transaction. At runtime, when a set of operations in a batch is defined as part of a single operation, the Commit After action is sent after the last operation in that transaction boundary. When an operation from the subset of the batch operation fails, it is handled by throwing a fault to the client. This option is only available with batch operations.