Siebel Energy Guide > Defining Integration Workflows for Siebel Energy >

Sample Integration Workflow: CUT Receive Account Data


This topic examines a receive-type sample workflow process to help you understand how the workflow process is set up.

This sample workflow process receives an XML string from an IBM MQSeries queue and updates the Account instance in the Siebel database.

Figure 27 shows this workflow.

Figure 27. CUT Receive Account Data Workflow Process

Workflow Description. This workflow performs the following actions:

  1. Receive Account Update. This step uses the Receive method of the EAI MQSeries Server Transport business service to retrieve the inbound message from the Account physical queue. This queue is named in the Physical Queue Name argument.

    In this case, the output from the receive step is put into the Account XML process property. The assumption is that the inbound message is already in XML format.

  2. Convert to Internal. This step uses the XML Document to Integration Object Hierarchy method of the Siebel EAI XML Converter business service to convert the inbound message to the Siebel business object format.

    The output argument from this step is stored in the Account Message process property, in the Siebel Message format.

  3. Update Account. This step uses the Insert or Update method of the EAI Siebel Adapter business service to perform the updating task. The EAI Siebel Adapter business service checks the Siebel database for an Account record that matches the current instance of Account in the Account Message property, and completes the following actions:
    • If an Account record matching the current instance does not appear in the database, then the adapter inserts the record into the database.
    • If an Account record in the database matches the current instance, then the adapter updates the record with the instance.

CUT Receive Account Data Workflow Properties

Set workflow process properties when you need a property to be true for the entire workflow. For example, the CUT Receive Account Data workflow process has five properties. The Error Message, Error Code, Object Id, and Siebel Operation Object Id properties are included in each workflow process by default. The Account XML property defines the MQSeries message as XML recognizable by Oracle's Siebel Business Applications.

The CUT Receive Account Data workflow process has the following additional properties:

  • Account Message. Contains the object in its Siebel Energy hierarchical format when converted. It must be in this format before it can be inserted or updated in Siebel Energy.
  • Account XML. Specifies the Siebel object that has been converted to XML.
  • Process Instance Id. Specifies the process instance and is automatically populated when a process is executed and persistence is enabled.
Siebel Energy Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.