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

QueryCustomerPartyEBM


QueryCustomerPartyEBM is used to retrieve customer data from Oracle FLEXCUBE Universal Banking.

Operation

Query

Service Consumer

Siebel CRM

Service Provider

Oracle FLEXCUBE Universal Banking

EBM Request and Response Operational Elements
  • QueryCustomerPartyEBM/QueryCustomerPartyEBM/DataArea/QueryCustomerParty
  • QueryCustomerPartyResponseEBM/DataArea/QueryCustomerPartyResponse

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

QueryCustomerPartyEBM

Table 26 lists the mapping information for the QueryCustomerPartyEBM.

Table 26. QueryCustomerPartyEBM
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 Compo-nent
Siebel Account Field

/Identification
/ID

FCUBS
Customer
Service

ST-Query
Customer-Req-IO-MSG.xsd

FCUBS_REQ_ENV/FCBUBS
_BODY
/Customer-Full/CUSTNO

Contact

Integration Id

Account

Integration Id

/Identification
/ContextID

FCUBS
Customer
Service

ST-Query
Customer-Req-IO-MSG.xsd

FCUBS_REQ_ENV/FCBUBS
_BODY
Customer-Full/LBRN

BIB Contact BC

Branch Code

BIB Account BC

Branch Code

/Identification
/Application
ObjectKey/ContextID

FCUBS
Customer
Service

ST-Query
Customer-Req-IO-MSG.xsd

FCUBS_REQ_ENV/FCBUBS
_BODY
Customer-Full/CTYPE

Not applicable

Not applicable

Not applic-able

Not applicable

/Identification
/Application
ObjectKey/ID

FCUBS
Customer
Service

ST-Query
Customer-Req-IO-MSG.xsd

FCUBS_REQ_ENV/FCBUBS
_BODY
Customer-Full/XREF

Contact

 

Id

 

Account

 

Id

 

QueryCustomerPartyResponseEBM

Table 27 lists the mapping information for the QueryCustomerPartyResponseEBM.

Table 27. QueryCustomerPartyResponseEBM
XML Path
Oracle FLEXCUBE Service Name
Oracle FLEXCUBE 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_ENVFCBUBS_
BODY/Customer-Full/CUSTNO

Contact

Integration Id

Account

Integration Id

/Identification
/Application
ObjectKey/ID

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Customer-Full/XREF

Contact

 

Id

 

Account

 

Id

/Identification
/Application
ObjectKey/ContextID

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Customer-Full/CUSTTYPE

Not applicable

Not applicable

Not applic-able

Not applicable

/Customer
Party
Financial
ServiceProfile/AntiMoney
Laundering
Check
Required
Indicator

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Customer-Full/AMLREQD

 

BIB Contact BC

AML Required

 

 

BIB Account BC

 

 

AML Required Flag

/Classification
Code

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Customer-Full/CUSTCLASS
FN

Contact

Customer Value

Account

Account Value

 

/Customer
PartyFinancial
ServiceProfile/Relationship
Pricing
Allowed
Indicator

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Customer-Full/RPCUST

BIB Contact BC

 

RP Customer

BIB Account BC

Relation-
ship Pricing Customer Flag

/TaxCode

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Customer-Full/TAXGROUP

Contact

Tax Code

 

BIB Account BC

Tax Code

/Customer
PartyCredit
Profile
/Customer
PartyLineOf
Credit/Identification
/ID

Not applicable

Not applicable

Derived field. Liablity Code and Line Serial appended.

BIB Contact Limit Line Items BC

Line ID

 

BIB Account Limit Details BC

 

Line ID

/Customer
PartyCredit
Profile
/Customer
PartyLineOf
Credit/Available
Amount/@Currency
Code

Not applicable

Not applicable

Derived field. Line Currency taken from table.

BIB Contact Limit Line Items BC

 

Line Currency

BIB Account Limit Details BC

Line Currency

 

/Customer
Party
CreditProfile
/Customer
PartyLineOf
Credit
Available
Amount

Not applicable

Not applicable

Derived field. Available amount taken from table.

BIB Contact Limit Line Items BC

 

Available amount

 

BIB Account Limit Details BC

 

Available amount

 

/Customer
PartyCredit
Profile/Customer
PartyLineOf
Credit/Parent
LineOfCredit
Reference
/LineOfCredit
Identification
/ID

Not applicable

Not applicable

Derived field. Main Line taken from table.

FINS BIB Limit Details

 

 

Main Line Number

 

FINS BIB Limit Details

 

Main Line Number

 

/Customer
Party
Financial
Account
/Financial
Account
/Financial
Account
Holder
/SignatureID

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Cust
Summary
Details/CUST
SIGNDTL
/CIFSIGID

BIB Contact Signator-ies VBC

 

Authorised Signatory Identifica-tion

BIB Account Signator-ies VBC

 

Authorised Signatory Identific-
ation

/Customer
PartyFinancialAccount
/FinancialAcc
ountFinancial
Account
Holder
/Financial
Account
PersonHolder
/PersonParty
Reference
/PersonName
/FullName

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Cust
Summary
Details/CUST
SIGNDTL
/CIFSIGNAME

BIB Contact Signator-ies VBC

Authorised Signatory Name

BIB Account Signator-ies VBC

Authorised Signatory Name

/Customer
PartyFinancial
Account/
FinancialAccount/Financial
Account
Holder
/Financial
Account
PersonHolder
/PersonParty
Reference
/PersonName
/Title

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Cust
Summary
Details/CUST
SIGNDTL/CIFSIGTITLE

BIB Contact Signator-ies VBC

Authorised Signatory Title

BIB Account Signator-ies VBC

Authorised Signatory Title

 

/PartyRelated
Party
/PartyRelated
PersonParty
/PersonParty
Reference/PersonName
/FullName

FCUBS
Customer
Service

ST-Query
Customer-Res-Full-MSG.xsd

FCUBS_RES_ENVFCBUBS_
BODY/Cust
Summary
Details/DIRDETAILS
/DIRNAME

 

Not applicable

 

 

BIB Account Directors VBC

Director Name

Not applicable

 

/Customer
Party
Specification
/Specification
/Name

Not applicable

Not applicable

Hard coded to Service
Provider.

Not applicable

Not applicable

Not applic-able

Not applicable

/Customer
Party
Specification
/Specification
/ValueText

Has to be removed.

Has to be removed.

Not shared to Siebel CRM. Has to be removed.

Not applicable

Not applicable

Account

 

 

Service Provider Flag

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