Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > EBM Mappings Used in Online Synchronization > ServiceRequestEBM >

QueryServiceRequestListEBM


QueryServiceRequestListEBM is used to retrieve service request data from Siebel CRM.

Operation

Query

Service Consumer

Oracle FLEXCUBE Universal Banking

Service Provider

Siebel CRM

EBM Request Operational Element
  • QueryServiceRequestListEBM/DataArea/Query/QueryCriteria/QueryExpression/ValueExpression
  • QueryServiceRequestListResponseEBM/DataArea/QueryServiceRequestListResponse

Information about the QueryServiceRequestListEBM request-and-response messages is provided in the following topics.

QueryServiceRequestListEBM

Table 45 lists the mapping information for the QueryServiceRequestListEBM request message.

Table 45. QueryServiceRequestListEBM
XML Path
Oracle FLEXCUBE Service Name
Oracle FLEXCUBE Interface Object
Oracle FLEXCUBE Interface Column
Siebel Contact Business Component
Siebel Contact Field

Element Path = "SR Number"

Element Value = <Value>

Not applicable

ST-QueryService-Request-Req-IO-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_REQ/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/SRNO

Service Request

SR Number

 

Element Path = "Customer Number"

Element Value = <Value>

Not applicable

ST-QueryService-Request-Req-IO-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_REQ/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/XREF

Service Request

Account Id

Contact Id

Element Path = "Customer Type"

Element Value = <Value>

Not applicable

Not applicable

 

Values are I or C (Individual customer, Corporate customer)

Service Request

Not applicable

QueryServiceRequestListResponseEBM

Table 46 lists the mapping information for the QueryServiceRequestListResponseEBM.

Table 46. QueryServiceRequestListResponseEBM
XML Path
Oracle FLEXCUBE Service Name
Oracle FLEXCUBE Interface Object
Oracle FLEXCUBE Interface Column
Siebel Contact Business Component
Siebel Contact Field

/Identification/ID

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/SRNO

Service Request

SR Number

 

/CategoryCode

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/SRTYPE

Service Request

INS Area

/Summary

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/SUBJECT

Service Request

Abstract

 

/Description

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/DESCRIPTION

Service Request

Description

 

/PriorityCode

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/PRIORITY

Service Request

Priority

 

/Status/Code

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/STATUS

Service Request

Status

 

/CustomerParty
Reference/Party
Identification/ID

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

 

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/CUSTNO

Service Request

 

Not applicable

/CustomerParty
Reference/Party
Identification/ApplicationObject
Key/ID

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/XREF

Service Request

Account ID

 

/CustomerParty
Reference/Party
Identification/ApplicationObject
Key/ContextID

Not applicable

Not applicable

Values are I or C
(Individual customer, Corporate customer)

Not applicable

Not applicable

/CustomerParty
Reference/CustomerParty
Account
Identification/ID

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

 

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/CUSTACNO

Service Request

Contact Financial Accounts

Asset Number

/ServiceRequest
Origination
BusinessUnit/ParentBusiness
UnitReference/BusinessUnit
Identification/ID

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/BRN

Service Request

Branch Code

/ExpectedClose
DateTime

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/TargetDate

Service Request

Commit Time

/CreationDate
Time

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/CONTACTDATE

Service Request

Created

/CloseRequest
DateTime

Not applicable

ST-QueryService-Request-Res-Full-MSG.xsd

FCUBS_QUERYSERVICEREQUEST_RES/FCUBS_
BODY/BLK_SERVICE_
REQUEST_DETAILS/ACTDATE

Service Request

Closed Date

Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.