Invoke Integration Object Activity

You can use the InvokeIntegrationObject Activity to perform the insert, upsert, update, delete, or query operation using the integration object or component.

General

The following table lists the configurations in the General tab of the Invoke Integration Object activity:

Field Module Property? Description
Name The name of the activity will be displayed.
Siebel Connection Yes Specify the Siebel Connection type that should be used. See the topic Creating a Siebel Connection using the Siebel Connection Resource for more details.
Operation Specify the operation that has to be performed using the activity. The following operations can be performed using the activity:
  • Insert- for inserting a new record
  • Upsert- for inserting a record if the record does not exist or for updating a record if it exists.
  • Update- for updating an existing record.
  • Delete- for deleting an existing record
  • Query- for querying or searching a record or records
Note:
  • The Update operation cannot be performed on a user-key field. For example, if you want to update the Location field from City1 to City 2, and if the Location field is a user-key, the update operation will generate an error.
  • The Upsert operation cannot be performed on multiple records. An exception is displayed if Upsert is performed on multiple records.
  • If you perform the Delete operation on a record, the output data for the record will have no values.
  • If you execute a Query operation without input values provided to the selected fields, an error is displayed on the console.
  • If the Delete operation finds multiple records, it deletes all the records without prompting you for a confirmation. For example, if you provide an input of a* and perform the delete operation, all records starting from the letter a is deleted. To delete all the records, provide * as an input.
Siebel Object Reference
Note: Only the Integration Object is supported by this activity.

Specify the object for reference created using the editor. See the topic Creating a Siebel Schema using the Siebel Objects Editor for more details.

  1. Click the search icon. The Siebel Integration Object dialog is displayed.
  2. Select an appropriate object.

Description

In the Description tab, you can enter a short description for the Invoke Integration Object activity.

Input

The values in the Input tab will be populated based on the object selected in the Siebel Object Reference field.

Note: Duplication or adding multiple Item fields in the Input tab is not allowed as Siebel only supports a single parent node or a parent-children relationship in the nodes.

Output

The values in the Output tab will be populated based on the values passed to the fields of the objects in the Input tab. If the process execution completes successfuly, you can see the output, otherwise a Fault will be displayed.

Fault

In the Fault tab, you can find the error message and error message code of the Invoke Integration Object activity. See the Error Codes topic for more detailed explanation of errors.

The following table lists the error schema elements in the Fault tab of the Invoke Integration Object activity:

Error Schema Element Data Type Description
SiebelPluginException String Will display an exception at runtime if the user has selected the attributes, has not assigned any values to the attributes, and is trying to perform the Insert, Upsert, Query, or Delete operation.
SiebelJDBException String Will display an exception related to the Siebel operation. The exception will be generated either by the Siebel server or due to operation failure.