Siebel Finance Guide > Workflow Reference for Oracle FLEXCUBE Universal Banking in Siebel Finance > Oracle FLEXCUBE Universal Banking Workflow Reference >

FINS BIB Service Request Info Upsert SYNC Workflow


FINS BIB Service Request Info Upsert SYNC Workflow, shown in Figure 6, creates a service request in Oracle FLEXCUBE Universal Banking and sends the data to Siebel Finance. Siebel Finance then creates a service request against a contact or an account and then sends the service request ID to Oracle FLEXCUBE Universal Banking for cross maintenance.

Figure 6. FINS BIB Service Request Info Upsert SYNC Workflow
Click for full size image

Workflow Description. This workflow does the following:

  1. XML Doc to XML Hierarchy. This step converts the XML message into XML hierarchy. This step calls the IntObjHierToXMLHier method.
  2. GetMessageId. This step extracts the SenderMessageId sent by Oracle FLEXCUBE Universal Banking in the payload using FINS Industry XML Query Service's Execute method.
  3. XMLHier to XMLDoc. This step converts the XML hierarchy to an XML document using the IntObjHierToXMLDoc method from the EAI XML Converter service.
  4. XSLT EIO to IIO. This step transforms the message in the EBM message structure to Siebel IO using the EAI XSLT Service.
  5. XMLDocToHier. This step converts the XML doc to Siebel Hierarchy using the XMLDocToIntObjHier method from the EAI XML Convertor service.
  6. Siebel EAI Adapter (Insert). This step inserts the record into the Siebel Finance database using EAI Siebel Adapter service's Insert method.
  7. Query SR. Using EAI Siebel Adapter's Query method, this step queries for the service request record that was created in Step 6.
  8. Query Output to XML Hierarchy. This step converts SiebelMessage into XML Hierarchy using the IntObjHierToXMLHier method of the EAI XML Convertor service.
  9. Get SR Number. This step uses the FINS Industry XML Query Service's Execute method to retrieve the Commit Time, SR Number and Opened Date from the XML Hierarchy in Step 8.
  10. XSLT IIO to EIO. Using EAI XSLT service's Transform method, this step converts the SiebelMessage into XML Hierarchy that is in an EBM message format.
  11. Hierarchy to XML Doc. This step converts the XML Hierarchy in Step 10 to XML doc.
  12. Error Handling XSLT Transform. Any error in any of the steps is captured and converted into an EBM message format using EAI XSLT Service's Transform method.
Siebel Finance Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.