Siebel Innovation Pack 2014: QueryCustomerPartyListEBM

QueryCustomerPartyListEBM is used to retrieve contact or account data from Siebel CRM and to retrieve prospect data from Siebel CRM.

Operation

Service Consumer

Service Provider

EBM Request and Response Operational Elements

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

QueryCustomerPartyListEBM

Table 28. QueryCustomerPartyListEBM
EBM Request Opera- tional Element	XML Path	Oracle FLEX-CUBE Service Name	Oracle FLEX-CUBE Interface Object	Oracle FLEX-CUBE Interface Column	Siebel Contact Business Compon-ent	Siebel Contact Field	Siebel Account Business Compon-ent	Siebel Account Field
/Query Customer PartyList EBMData Area Query /Query Criteria /Query Expres sion /Value Express ion	Element Path = "Custom er No" Element Value = <Value>	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_ REQ_ENV /FCBUBS_ BODY/Customer-Full/CUSTNO	Contact	Integra-tion Id	Account	Integra-tion Id
	Element Path = "First Name" Element Value = <Value>	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_REQ_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/FSTNAME	Contact	First Name	Not applic-able	Not applic-able
	Element Path =" Last Name" Element Value = <Value>	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_REQ_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/LSTNAME	Contact	Last Name	Not applic-able	Not applic-able
	Element Path =" Phone Number" Element Value = <Value>	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_REQ_ENV/FCBUBS_BODY/Customer-Full/Cust personal/TEL	Contact	Work Phone # Cellular Phone # Home Phone #	Account	Main Phone Number
	Element Path = "Name" Element Value = <Value>	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_REQ_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/CORP NAME	Not applicable	Not applic-able	Account	Name
	Element Path = "Alias" Element Value = <Value>	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_REQ_ENV/FCBUBS_ BODY/Customer-Full/SNAME	Not applicable	Not applic-able	Account	Alias
/Query Customer PartyList EBM/Data Area/Query/	/Query Customer PartyList EBM/DataArea/Query/Query Code	FCUBS Customer Service	ST-Query Customer-Req-IO-MSG.xsd	FCUBS_REQ_ENV/FCBUBS_ BODY/Customer-Full/CTYPE	Contact	Type	Account	Type
/Query CustomerPartyList EBM	/Query Customer PartyList EBM/Data Area/Query/maxItems	NA	NA	Value is OK if Contain records is less than or equal to Max Items Value is OVER FLOW if Contain records equals MaxItems	Contact	Not applic-able	Account	Not applic-able

QueryCustomerPartyListResponseEBM

Table 29 lists the mapping information for the QueryCustomerPartyListResponseEBM.

Table 29. QueryCustomerPartyListResponseEBM
XML Path	Oracle FLEXCUBE Service Name	Oracle FLEXCUBE Interface Object	Oracle FLEXCUBE Interface Column	Siebel Contact Business Compon-ent	Siebel Contact Field	Siebel Account Business Compon-ent	Siebel Account Field
/Identification /ID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CUSTNO	Contact	Integration Id	Account	Integration Id
/Identification /Application ObjectKey/ID	FCUBS Customer Service	ST-Modify Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/XREF	Contact	Id	Account	id
/Identification /Application ObjectKey /ContextID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CTYPE	Not applicable	Not applicable	Not applicable	Not applicable
/PartyLocation /Location Reference/Address/LineOne	FCUBS Customer Service	ST-Modify Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN1	CUT Address	Street Address	CUT Address	Street Address
/PartyLocation /Location Reference/Address/LineTwo	FCUBS Customer Service	ST-Modify Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN2	CUT Address	Street Address 2	CUT Address	Street Address 2
/PartyLocation /Location Reference/Address/LineThree	FCUBS Customer Service	ST-Modify Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN3	CUT Address	City	CUT Address	City
/PartyLocation /Location Reference/Address/LineFour	FCUBS Customer Service	ST-Modify Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ADDRLN4	Not applicable	Not applicable	Not applicable	Not applicable
/PartyLocation /Location Reference/Address/CountryCode	FCUBS Customer Service	ST-Modify Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/COUNTRY	CUT Address	Country	CUT Address	Country
/PartyContact /Contact/ContactPhone Communica tion/PhoneComm unication/Complete Number	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/TEL	Contact	Work Phone #	Not applicable	Not applicable
/PartyContact /Contact/ContactFax Communica tion/FaxComm unication/Complete Number	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custpersonal/FAX	Contact	Fax Phone #	Not applicable	Not applicable
/PartyContact /Contact/ContactEmail Communica tion/EmailComm unication/URI	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custpersonal/EMAIL	Contact	Email Address	Not applicable	Not applicable
/Person/GenderCode	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/SEX	Contact	M/F	Not applicable	Not applicable
/Person/MaritalStatus Code	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/MARTIALSTAT	Contact	Marital Status	Not applicable	Not applicable
/Person/BirthDateTime	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/DOB	Contact	Birth Date	Not applicable	Not applicable
/Person/Language Code	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LANG	Contact	Language Code	Not applicable	Not applicable
/Person/Nationality CountryCode	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personalNLTY	Contact	Citizenship	Not applicable	Not applicable
/Person/RentOrOwn Code	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/ACCOMADATE	Contact	Own or Rent	Not applicable	Not applicable
/Person/Deceased Indicator	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/DEAD	Contact	Deceased Flag	Not applicable	Not applicable
/Person/PersonName /FirstName	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/FSTNAME	Contact	First Name	Not applicable	Not applicable
/Person/PersonName /MiddleName	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/MIDNAME	Contact	Middle Name	Not applicable	Not applicable
/Person/PersonName /FamilyName	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS _BODY/Customer-Full/Cust personal/LSTNAME	Contact	Last Name	Not applicable	Not applicable
/Person/PersonName /Title	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/TITLE	Contact	M/M	Not applicable	Not applicable
/Person/PersonName /Alias	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/SNAME	Contact	Alias	Not applicable	Not applicable
/Person /Education Record /MajorCourse Category	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/EDUSTAT	Contact	FINS Education	Not applicable	Not applicable
/Person/Employment Record /Employer Organization Name	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/CURREMP	Contact	Employer Name Free Text	Not applicable	Not applicable
/Person /Employment Record /JobTitle	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/CURR DESIG	Contact	Job Title	Not applicable	Not applicable
/Organization /Name	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/CORPNAME	Not applicable	Not applicable	Account	Name
/Organization /LineOf Business	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/CORPDESC	Not applicable	Not applicable	Account	Line of Business
/Person/TaxPayer IdentificationNumber	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/SSN	Contact	SSN	Not applicable	Not applicable
/Organization /Home CountryCode	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/NLTY	Not applicable	Not applicable	BIB Account BC	Country of Incorpora- tion
/Organization /BankBranch Reference /BankBranch Identification /ID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LBRN	Not applicable	Not applicable	BIB Account BC	Branch Code
/LevelCode	Not applicable	Not applicable	Values provided are PROSPECT,CUSTOMER	Contact	Status	Account	Account Status
/Customer PartyCredit Profile/Credit RatingCode	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CRRATE	BIB Contact BC	Credit Rating	Account	Credit Rating
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/Party Identification /Application ObjectKey/ID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Relation ship-Linkage/CUSTOMER	Not applicable	Not applicable	Not applicable	Not applicable
/PartyRelated Party/ PartyRelated PersonParty /PersonParty Reference /Party Identification /Application ObjectKey /ContextID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Relation ship-Linkage/XREF	Not applicable	Not applicable	Not applicable	Not applicable
/PartyRelated Party /Party Relationship /Relationship Code	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust accdet/Relation ship-Linkage/RELATIONSHIP	Party Relation- ship To	Relation- ship Type	Party Relation- ship To	Relation- ship Type
/Customer Party Specification /Specification /Name	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_RES_ENV/FCBUBS_ BODY/Customer-Full/UIDNAME	Contact	ID Type	Not applicable	Not applicable
/Customer Party Specification /Specification /ValueText	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/UIDVAL	Contact	ID Informa-tion	Not applicable	Not applicable
/Customer PartyFinancialServiceProfile /Financial Institution Branch BusinessUnit Reference/BusinessUnit Identification /iD	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LBRN	BIB Contact BC	BIB Contact BC	Not applicable	Not applicable
/PartyContact /Contact /Preferred Communica tion ChannelCode	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/MEDIA	Contact	Preferred Communi-cation Method	Account	Preferred Communi-cation Method
/Person /Personal National Identity /TypeCode	Not applicable	Not applicable	Not applicable	Contact	Other ID Type	Not applicable	Not applicable
/Person /Personal National Identity /Identification /ID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/PPTNO	Contact	Other ID Number	Not applicable	Not applicable
/Resident Indicator	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/STATUS	BIB Contact BC	Permenant Resident	Not applicable	Not applicable
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PersonName /FullName	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/SPNAME	Contact	Spouse Name	Not applicable	Not applicable
/Person Total Dependent Count	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Cust domestic/DEPOTH	BIB Contact BC	Number Of Depend-ents	Not applicable	Not applicable
/Person /Employment Record /PositionType Code	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS _RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/EMPSTAT	BIB Contact BC	Employ-ment Status	Not applicable	Not applicable
/Person/Employment Record/Employment Duration	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof /EMPTEN-URE	BIB Contact BC	Years Employed	Not applicable	Not applicable
/Person /Personal Income Amount	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/SALARY	FIN Contact Income	Amount	Not applicable	Not applicable
/Potential Revenue Amount	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Cust personal/Custprof/OTH INCOME	FIN Contact Income	Amount	Not applicable	Not applicable
/Organization /Incorpora tionDate	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/Custcorp/INCORPDT	Not applicable	Not applicable	Account	Date Formed
/Organization/ShortName	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS _RES_ENV/FCBUBS_ BODY/Customer-Full/SNAME	Not applicable	Not applicable	Account	Alias
/Classification Code	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CUST CLASSFN	Contact	Customer Value	Account	Account Value
/Customer PartyFinancial ServiceProfile /Financial Institution Reference /Party Identification /ID	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/LBRN	BIB Contact BC	Bank Code	BIB Account BC	Bank Code
/Organization/Incorporation CountryCode	FCUBS Customer Service	ST-Query Customer-Res-Full-MSG.xsd	FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/ INCORP CNTRY	Not applicable	Not applicable	BIB Account BC	Country of Incorpora- tion
/EBMHeader /Sender /Transaction Code	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable

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