Invoke Business Object Activity

You can use the InvokeBusinessObject Activity to select and configure the Siebel business object or component to perform the insert, upsert, delete, and query operations using the Siebel fields.

General

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

Field Module Property? Description
Name The name of the activity is 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.
  1. Click the search icon. A dialog box is displayed listing the connections.
  2. Select an appropriate connection.
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.
  • Delete- for deleting an existing record
  • Query- for querying or searching a record or records
Note:
  • The operations Insert, Upsert, and Delete is performed even if you select and provide the values for the Hidden, Inactive, Calculated, and the Read only fields. There are no changes on the Siebel server for these fields. For example, if you provide input as "*" and perform the delete operation, all records are deleted.
  • The Upsert operation cannot be performed on multiple records in both case parent and parent-child combinations which has multiple records.
  • 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.
  • If you execute a Query operation without input values provided to the selected fields, an error is displayed on the console.
  • When any operation like Query is taking more time than configured in the TIBCO BusinessWorks Studio (default is 3 minutes) then you must increase the timeout in Studio to avoid timeout exception.
  • If a parent-child relationship exists, the Delete operation is not performed.
Siebel Object Reference
Note: Only the Business Object is supported by this activity.

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

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

Description

In the Description tab, you can enter a short description for the Invoke Business 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 supports only a single parent.

Output

If the Query operation is successful, the data received from Siebel server gets displayed on the Output tab.

For the Invoke Business Object activity only the status and Object ID are displayed as the output. If the process executes without any error, it will show the ID, which is received from the Siebel server. If the process fails a Fault will be generated. The error or an exception will be displayed in the Fault tab.

Fault

In the Fault tab, you can find the error message and error message code of the Invoke Business 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 Business Object activity:

Error Schema Element Data Type Description
SiebelPluginException String Exceptions like key field validation, match field validation, etc will be displayed.
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.