Bookshelf Home | Contents | Index | PDF     

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

QueryMarketingOfferEBM

The QueryMarketingOfferEBM integration objects, associated with the MarketingOfferEBO, are used in query operations in the Integration to retrieve offers from Siebel CRM with a status of Contact Specific - Active. The application mappings used by the QueryMarketingOfferEBM integration objects for the query operation are described in this topic.

Operation

Query

Service Consumer

Oracle FLEXCUBE Universal Banking

Service Provider

Siebel CRM

EBM Request and Response Operational Elements
  • QueryMarketingOfferListEBM/DataArea/Query/QueryCriteria/QueryExpression/ValueExpression
  • QueryMarketingOfferListResponseEBM/DataArea/QueryMarketingOfferListResponse

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

QueryMarketingOfferEBM

Table 38 lists the mapping information for the QueryMarketingOfferEBM.

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

Element Path = "Customer Number" Element Value = <Value>

Not applicable

ST-QueryOffer
Service-Req-IO-MSG.xsd

FCUBS_QUERYOFFERDETAILS_REQ
/FCUBS_BODY/BLK_
QUER_RESULT/CUSTNO

Campaign List Contact

Contact Id

QueryMarketingOfferResponseEBM

Table 39 lists the mapping information for the QueryMarketingOfferResponseEBM.

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

/Name

Not applicable

ST-QueryOffer
Service-Res-Full-MSG.xsd

FCUBS_QUERYOFFERDETAILS_RES/FCUBS_BODY
/BLK_QUER_RESULT/OFFERDESC

Parent Offer

Name

 

/EffectiveTime
Period/Start
DateTime

Not applicable

 

ST-QueryOffer
Service-Res-Full-MSG.xsd

FCUBS_QUERYOFFERDETAILS_RES/FCUBS_BODY
/BLK_QUER_RESULT/FRMDT

Parent Offer

Valid Start Date

/EffectiveTime
Period/EndDate
Time

Not applicable

ST-QueryOffer
Service-Res-Full-MSG.xsd

FCUBS_QUERYOFFERDETAILS_RES/FCUBS_BODY
/BLK_QUER_RESULT/TODT

Parent Offer

Valid End Date

/Identification
/ID

Not applicable

 

ST-QueryOffer
Service-Res-Full-MSG.xsd

FCUBS_QUERYOFFERDETAILS_RES/FCUBS_BODY
/BLK_QUER_RESULT/OFRCD

Parent Offer

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