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

CreateSalesOpportunityEBM


The CreateSalesOpportunityEBM integration object, associated with the SalesOpportunityEBO, is used in the following create operations in the Integration:

  • Create lead in Siebel CRM using existing customer and product
  • Create lead in Siebel CRM using product
  • Create lead in Siebel CRM using existing customer and offer
  • Create lead in Siebel CRM using offer

The application mappings used by the CreateSalesOpportunityEBM integration object for this operation are described in this topic.

Operation

Create

Service Consumer

Oracle FLEXCUBE Universal Banking

Service Provider

Siebel CRM

EBM Request Operational Element

CreateSalesOpportunityEBM/DataArea/CreateSalesOpportunity

Table 41 lists the mapping information for the CreateSalesOpportunityEBM request message.

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

/Note/Content

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/REMARKS

Lead

Description

/CustomerParty
Reference/PartyIdentification/ID

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/CUSTNO

Lead

 

Not applicable

/CustomerParty
Reference/Party
Identification/ApplicationObjectKey/ID

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/XREF

Lead

Contact Id

Account Id

/CustomerParty
Reference/Party
Identification/ApplicationObjectKey/ContextID

Not applicable

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

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

Lead

 

Not applicable

/CustomerParty
Reference/OrganizationName

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/CORPORATE_NAME

List Mgmt Prospective Contact

Account

/CustomerParty
Reference/Person
Name/FirstName

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/FSTNM

Lead

Contact First Name

 

/CustomerParty
Reference/Person
Name/FamilyName

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/LSTNM

Lead

Contact Last Name

Prospect First Name

/CustomerParty
Reference/Contact
/ContactPhone
Communication
/PhoneCommunication
/CompleteNumber

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/TELEPHONE

 

Lead

 

Prospect Work Phone

 

/CustomerParty
Reference/Contact
/ContactEmail
Communication
/EmailCommunication
/URI

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/EMAIL

Lead

 

Prospect Email Address

 

 

/CustomerParty
Reference/Location
Reference/Address/LineOne

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/ADDRESS1

List Mgmt Prospective Contact

Street Address

/CustomerParty
Reference/Location
Reference/Address/LineTwo

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/ADDRESS2

List Mgmt Prospective Contact

Street Address 2

/CustomerParty
Reference/Location
Reference/Address/LineThree

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/ADDRESS3

List Mgmt Prospective Contact

City

 

 

/CustomerParty
Reference/Location
Reference/Address/Line Four

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/ADDRESS4

Not applicable

Not applicable

/CustomerParty
Reference/Location
Reference/Address/StateName

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/ADDRESS4

List Mgmt Prospective Contact

State

/CustomerParty
Reference/Location
Reference/Address/PostalCode

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/ADDRESS4

List Mgmt Prospective Contact

Postal Code

/SalesOpportunity
Line/Status/Code

Not applicable

Not applicable

 

Not applicable

Lead

Lead Status

/SalesOpportunity
Line/ItemReference/ItemIdentification/ID

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/Leadprod-Details/PROUCT_CODE

Lead

Product Interest

Offer Number

/SalesOpportunity
Line/ItemReference/TypeCode

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/Leadoffer-Details/OFFRCD

Not applicable

 

Not applicable

 

/SalesOpportunity
Line/Status/Code

Not applicable

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

FCUBS_RES_ENV/FCUBS_BODY/Lead-Details-Full/Leadoffer-Details/RESPONSE

Response

Outcome Code

/SalesOpportunity
Source/Business
UnitReference
/BusinessUnit
Identification/ID

Not applicable

Not applicable

 

Branch Code

 

Not applicable

 

Not applicable

 

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