10EBM Mappings Used in Online Synchronization
EBM Mappings Used in Online Synchronization
This appendix lists the mappings between data in Oracle FLEXCUBE Universal Banking and data in Siebel CRM that are used during the online synchronization of data in Siebel CRM Integration to Oracle FLEXCUBE Universal Banking.
This chapter includes the following topics:
CustomerPartyEBM
The CustomerPartyEBM integration objects, associated with the Customer Party EBO, are used in create, update and query operations in the Integration. The application mappings used by the CustomerPartyEBM integration objects for each of these operations is provided in the following topics:
CreateCustomerPartyEBM
CreateCustomerPartyEBM is used to synchronize customers created in Oracle FLEXCUBE Universal Banking with Siebel CRM.
Operation
Create
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request and Response Operational Elements
The elements are as follows:
CreateCustomerPartyEBM
CreateCustomerPartyResponseEBM
Information about the CreateCustomerPartyEBM request-and-response messages is provided in the following topics.
CreateCustomerPartyEBM
The following information lists the mapping information for the CreateCustomerPartyEBM.
Table CreateCustomerPartyEBM
| 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-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIER /Customer-Full /CUSTNO |
Contact |
Integration Id |
Account |
Integration Id |
/Identification /Application ObjectKey /ContextID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIER /Customer-Full/CTYPE |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference /Address /LineOne |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIER/Customer-Full /ADDRLN1 |
CUT Address |
Street Address |
CUT Address |
Street Address |
/PartyLocation /Location Reference /Address /LineTwo |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/ADDRLN2 |
CUT Address |
Street Address 2 |
CUT Address |
Street Address 2 |
/PartyLocation /Location Reference /Address /LineThree |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/ADDRLN3 |
CUT Address |
City |
CUT Address |
City |
/PartyLocation /Location Reference /Address /LineFour |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/ADDRLN4 |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference /Address /CountryCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/COUNTRY |
CUT Address |
Country |
CUT Address |
Country |
/PartyLocation /Location Reference /Location Identification /Alternate ObjectKey/Id |
Not applicable |
Not applicable |
Value provided is Y (Indicating primary address) |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyContact /Contact /Contact PhoneCommunication/ PhoneCommunication /Complete Number |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal/TEL |
Contact |
Work Phone# |
Not applicable |
Not applicable |
/PartyContact /Contact /ContactFax Communica tion /FaxCommun ication /Complete Number |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal /FAX |
Contact |
Fax Phone # |
Not applicable |
Not applicable |
/PartyContact /Contact /ContactEmail Communica tion /EmailComm unication/URI |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal /EMAIL |
Contact |
Email Address |
Not applicable |
Not applicable |
/Person /GenderCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal /SEX |
Contact |
M/F |
Not applicable |
Not applicable |
/Person /MaritalStatus Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust domestic /MARTIAL STAT |
Contact |
Marital Status |
Not applicable |
Not applicable |
/Person /BirthDate Time |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /DOB |
Contact |
Birth Date |
Not applicable |
Not applicable |
/Person /Language Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LANG |
Contact |
Language Code |
Not applicable |
Not applicable |
/Person /Nationality CountryCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal NLTY |
Contact |
Citizenship |
Not applicable |
Not applicable |
/Person /RentOrOwn Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic/ACCOMADATE |
Contact |
Own or Rent |
Not applicable |
Not applicable |
/Person /Deceased Indicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/DEAD |
Contact |
Deceased Flag |
Not applicable |
Not applicable |
/Person /PersonName /FirstName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/FSTNAME |
Contact |
First Name |
Not applicable |
Not applicable |
/Person /PersonName /MiddleName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/MIDNAME |
Contact |
Middle Name |
Not applicable |
Not applicable |
/Person /PersonName /FamilyName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /LSTNAME |
Contact |
Last Name |
Not applicable |
Not applicable |
/Person /PersonName /Title |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /TITLE |
Contact |
M/M |
Not applicable |
Not applicable |
/Person /PersonName /Alias |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/SNAME |
Contact |
Alias |
Not applicable |
Not applicable |
/Person /Education Record /MajorCourse Category |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic /EDUSTAT |
Contact |
FINS Education |
Not applicable |
Not applicable |
/Person /Employment Record /Employer Organization Name |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Custprof /CURREMP |
Contact |
Employer Name Free Text |
Not applicable |
Not applicable |
/Person /Employment Record /JobTitle |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Custprof/CURRDESIG |
Contact |
Job Title |
Not applicable |
Not applicable |
/Organization /Name |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custcorp/CORPNAME |
Not applicable |
Not applicable |
Account |
Name |
/Organization /LineOf Business |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custcorp/CORPDESC |
Not applicable |
Not applicable |
Account |
Line of Business |
/Person /TaxPayer Identification Number |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/SSN |
Contact |
SSN |
Not applicable |
Not applicable |
/Organization /Home CountryCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-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-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LBRN |
Not applicable |
Not applicable |
BIB Account BC |
Branch Code |
/LevelCode |
Not applicable |
Not applicable |
Values will be PROSPECT,CUSTOMER |
Contact |
Status |
Account |
Account Status |
/TypeCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CTYPE |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/TaxCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/TAXGROUP |
Contact |
Tax Code |
BIB Account BC |
Tax Code |
/Status/Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CCATEG |
Contact |
Type |
Account |
Type |
/Customer PartyCredit Profile/Credit RatingCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CRRATE |
BIB Contact BC |
Credit Rating |
Account |
Credit Rating |
/PartyRelated Party /PartyRelated PersonParty /PersonParty Reference /PartyIdentifi cation/ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custaccdet/Relation-ship-Linkage/CUSTOMER |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/Party RelatedPerson Party/Person Party Reference/PartyIdentific ation/Application ObjectKey/ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custaccdet/Relation-ship-Linkage /XREF |
Party Relation ship To |
Related Party Id |
Party Relation ship To |
Related Party Id |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PartyIdentific ation/Application ObjectKey/ContextID |
Not applicable |
Not applicable |
Values provided are I,C (Individual,Corporate) |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/Party Relationship /Relationship Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custaccdet /Relation-ship-Linkage/RELATION-SHIP |
Party Relation ship To |
Relation ship Type |
Party Relation ship To |
Relation ship Type |
Not provided by Oracle FLEXCUBE Universal Banking |
Not applicable |
Not applicable |
Not applicable |
Party Relation ship To |
Calculated Related Party Type |
Party Relation ship To |
Calculated Related Party Type |
/Customer PartySpecific ation /Specification /Name |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/UIDNAME |
Contact |
ID Type |
Not applicable |
Not applicable |
/Customer PartySpecific ation /Specification /ValueText |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/UIDVAL |
Contact |
ID Informa-tion |
Not applicable |
Not applicable |
/Customer PartyFinancialServiceProfile /Financial Institution Branch BusinessUnit Reference/BusinessUnit Identification/iD |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LBRN |
BIB Contact BC |
BIB Contact BC |
Not applicable |
Not applicable |
/PartyContact/Contact/Preferred Communica tionChannel Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/MEDIA |
Contact |
Preferred Communication Method |
Account |
Preferred Communication Method |
/Person/PersonalNationalIdentitiy /Identification /ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /PPTNO |
Contact |
Other ID Number |
Not applicable |
Not applicable |
/Customer PartyFinancialServiceProfile /Relationship PricingAllowed Indicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /RPCUST |
BIB Contact BC |
RP Customer |
BIB Account BC |
Relation ship Pricing Customer Flag |
/Person/ MinorIndicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /MINOR |
BIB Contact BC |
Minor Indicator |
Not applicable |
Not applicable |
/Resident Indicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-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-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic /SPNAME |
Contact |
Spouse Name |
Not applicable |
Not applicable |
/Person /TotalDepend entCount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-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-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /Custprof /EMPSTAT |
BIB Contact BC |
Employ- ment Status |
Not applicable |
Not applicable |
/Person/Employment Record/Employment Duration |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Custprof /EMP TENURE |
BIB Contact BC |
Years Employed |
Not applicable |
Not applicable |
/Person /Personal Income Amount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /Custprof /SALARY |
FIN Contact Income |
Amount |
Not applicable |
Not applicable |
/Potential Revenue Amount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /Custprof /OTH INCOME |
FIN Contact Income |
Amount |
Not applicable |
Not applicable |
/Organization /Incorporat ionDate |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /Custcorp /INCORPDT |
Not applicable |
Not applicable |
Account |
Date Formed |
/Organization /Organization FinancialStatement /Organization Financial Number /Amount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /Custcorp /NET WORTH |
Not applicable |
Not applicable |
BIB Account BC |
Customer Networth Amount |
/Person/Person Financial Profile /Financial Profile/Status/Code /Organization /Organization Financial Profile/Financial Profile/Status/Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /KYCSTAT |
BIB Contact BC |
KYC Status |
BIB Account BC |
KYC Status Flag |
/Organization /ShortName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/SNAME |
Not applicable |
Not applicable |
Account |
Alias |
/Customer PartyFinancial ServiceProfile /AntiMoney Laundering CheckReq uiredIndicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /AMLREQD |
BIB Contact BC |
AML Required |
BIB Account BC |
AML Required Flag |
/Classification Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CUST CLASSFN |
Contact |
Customer Value |
Account |
Account Value |
/Customer PartySpecific ation /Specification /ValueText |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/FLGUTL TYPRVDR |
Not applicable |
Not applicable |
Account |
Service Provider Flag |
/Customer PartyFinancial ServiceProfile /Financial Institution Reference/PartyIdentific ation/ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LBRN |
BIB Contact |
Bank Code |
BIB Account BC |
Bank Code |
/Person /Person Financial Profile/Financial Profile/Status/SubStatus Code /Organization/Organization Financial Profile/Financial Profile/Status/SubStatus Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/FROZEN |
BIB Contact BC |
Frozen |
BIB Account BC |
Frozen Flag |
/Status /SubStatus Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /WHRUNKN |
BIB Contact BC |
Where abouts Unknown |
BIB Account BC |
Where abouts Unknown Flag |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PersonName/FullName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /GUARDIAN |
BIB Contact BC |
Guardian Name |
Not applicable |
Not applicable |
/Customer PartyCredit Profile/Identification /ID |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/LIABLITY NO |
BIB Contact BC |
Liability Number |
BIB Account BC |
Liability Number |
/Customer PartyCredit Profile/CreditLimit Amount |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/OVERALL LIMIT |
BIB Contact BC |
Overall Limit Amount |
BIB Account BC |
Overall Limit Amount |
/Customer PartyCredit Profile/CurrencyCode |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/LIABLITY CCY |
BIB Contact BC |
Limit Currency Code |
BIB Account BC |
Limit Currency Code |
/Customer PartyCredit Profile/TotalUtilized LineOfCredit Amount |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/UTILISA TIONAMT |
BIB Contact BC |
Total Utilized Amount |
BIB Account BC |
Total Utilized Amount |
/Customer PartyCredit Profile/LastCredit ReviewDate |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/REVISION DATE |
BIB Contact BC |
Revision Date |
BIB Account BC |
Revision Date |
CreateCustomerPartyResponseEBM
The following information lists the mapping information for the CreateCustomerPartyResponseEBM.
Table CreateCustomerPartyResponseEBM
| 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 |
Not applicable |
Not applicable |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CUSTNO |
Contact |
Integration Id |
Account |
Integration Id |
/Identification /Application ObjectKey/ID |
Not applicable |
Not applicable |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/XREF |
Contact |
Id |
Account |
Id |
/Identification /Application ObjectKey/ContextID |
Not applicable |
Not applicable |
FCUBS_ RES_ENV/FCBUBS_ BODY/Customer-Full/CTYPE |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
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
The following information lists the mapping information for the QueryCustomerPartyEBM.
Table 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
The following information lists the mapping information for the QueryCustomerPartyResponseEBM.
Table 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 |
QueryCustomerPartyListEBM
QueryCustomerPartyListEBM is used to retrieve contact or account data from Siebel CRM and to retrieve prospect data from Siebel CRM.
Operation
Query
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request and Response Operational Elements
Request. See QueryCustomerPartyListEBM.
Response. /QueryCustomerPartyListResponseEBM/DataArea/QueryCustomerPartyListResponse
Information about the QueryCustomerPartyListEBM request-and-response messages is provided in the following topics.
QueryCustomerPartyListEBM
The following information lists the mapping information for the QueryCustomerPartyListEBM.
Table 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
The following information lists the mapping information for the QueryCustomerPartyListResponseEBM.
Table 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 |
UpdateCustomerPartyEBM
UpdateCustomerPartyEBM is used to:
Update Know Your Customer (KYC) data in Siebel CRM
Convert prospect to customer in Siebel CRM
Update customer name in Siebel CRM
Update customer address in Siebel CRM
Operation
Update
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request Operational Element
UpdateCustomerPartyEBM
The following information lists the mapping information for the UpdateCustomerPartyEBM.
Table UpdateCustomerPartyEBM
| 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-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICA TION/FCUBS_ NOTIF_IDENTIFIER/Customer-Full/CUSTNO |
Contact |
Integration Id |
Account |
Integra-tion Id |
/Identification /Application ObjectKey/ID |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_ NOTIF_IDENTIFIER/Customer-Full/XREF |
Contact |
Id |
Account |
id |
/PartyLocation /Location Reference /Address/Line One |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/ADDRLN1 |
CUT Address |
Street Address |
CUT Address |
Street Address |
/PartyLocation /Location Reference/Address/Line Two |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/ADDRLN2 |
CUT Address |
Street Address 2 |
CUT Address |
Street Address 2 |
/PartyLocation /Location Reference /Address/Line Three |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/ADDRLN3 |
CUT Address |
City |
CUT Address |
City |
/PartyLocation /Location Reference/Address/Line Four |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/ADDRLN4 |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference/Address/CountryCode |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/COUNTRY |
CUT Address |
Country |
CUT Address |
Country |
/Person/Nationality CountryCode |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/NLTY |
Contact |
Citizenship |
Not applicable |
Not applicable |
/Person /Deceased Indicator |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/DEAD |
Contact |
Deceased Flag |
Not applicable |
Not applicable |
/Person /PersonName /FirstName |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/FSTNAME |
Contact |
First Name |
Not applicable |
Not applicable |
/Person /PersonName /MiddleName |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/MIDNAME |
Contact |
Middle Name |
Not applicable |
Not applicable |
/Person/PersonName/FamilyName |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/LST NAME |
Contact |
Last Name |
Not applicable |
Not applicable |
/Person/PersonName/Title |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/TITLE |
Contact |
M/M |
Not applicable |
Not applicable |
/Person/PersonName/Alias |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/SNAME |
Contact |
Alias |
Not applicable |
Not applicable |
/Organization/Name |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custcorp/CORPNAME |
Not applicable |
Not applicable |
Account |
Name |
/Organization /HomeCountry Code |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/NLTY |
Not applicable |
Not applicable |
BIB Account BC |
Country of Incorpora-tion |
/Organization/BankBranch Reference/BankBranch Identification/ID |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/LBRN |
Not applicable |
Not applicable |
BIB Account BC |
Branch Code |
/LevelCode |
NA |
NA |
Values will be PROSPECT,CUSTOMER |
Contact |
Status |
Account |
Account Status |
/TaxCode |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/TAXGROUP |
Contact |
Tax Code |
BIB Account BC |
Tax Code |
/Customer PartyCredit Profile/Credit RatingCode |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/CRRATE |
BIB Contact BC |
Credit Rating |
Account |
Credit Rating |
/PartyRelated Party/PartyRelated PersonParty /PersonParty Reference /Party Identification/ID |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custaccdet/Relation ship-Linkage/CUSTOMER |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/Party Identification /Application ObjectKey/ID |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custaccdet/Relation ship-Linkage/XREF |
Party Relation-ship To |
Related Party Id |
Party Relation-ship To |
Related Party Id |
/PartyRelated Party /PartyRelated PersonParty /PersonParty Reference /Party Identification /Application ObjectKey/ContextID |
Not applicable |
Not applicable |
Values provided are I,C (Individual,Corporate) |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/Party Relationship/Relationship Code |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custaccdet/Relation ship-Linkage/RELATION SHIP |
Party Relation-ship To |
Relation- ship Type |
Party Relation-ship To |
Relation- ship Type |
Not provided by Oracle FLEXCUBE Universal Banking. |
Not applicable |
Not applicable |
Not applicable |
Party Relation- ship To |
Calculated Related Party Type |
Party Relation- ship To |
Calculated Related Party Type |
/Customer PartyFinancial ServiceProfile /Financial Institution Branch BusinessUnit Reference/BusinessUnit Identification /iD |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/LBRN |
BIB Contact BC |
Branch Id |
Not applicable |
Not applicable |
/Customer PartyFinancial ServiceProfile /Relationship PricingAllowed Indicator |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/RPCUST |
BIB Contact BC |
RP Customer |
BIB Account BC |
Relation-ship Pricing Customer Flag |
/Person/ MinorIndicator |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/MINOR |
BIB Contact BC |
Minor Indicator |
Not applicable |
Not applicable |
/Organization/Organization Financial Statement/Organization Financial Number/Amount |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custcorp/NETWORTH |
Not applicable |
Not applicable |
BIB Account BC |
Customer Networth Amount |
/Person/Person FinancialProfile/Financial Profile/Status /Code /Organization /Organization FinancialProfile/Financial Profile/Status /Code |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/KYCSTAT |
BIB Contact BC |
KYC Status |
BIB Account BC |
KYC Status Flag |
/Organization/ShortName |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/SNAME |
Not applicable |
Not applicable |
Account |
Alias |
/Customer PartyFinancial ServiceProfile/AntiMoney Laundering CheckRequiredIndicator |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/AMLREQD |
BIB Contact BC |
AML Required |
BIB Account BC |
AML Required Flag |
/Person/Person FinancialProfile/Financial Profile/Status/SubStatusCode /Organization/Organization FinancialProfile/Financial Profile/Status/SubStatusCode |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/FROZEN |
BIB Contact BC |
Frozen |
BIB Account BC |
Frozen Flag |
/Status/SubStatusCode |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/WHRUNKN |
BIB Contact BC |
Where-abouts Unknown |
BIB Account BC |
Where-abouts Unknown Flag |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PersonName/FullName |
FCUBS Customer Service |
ST-Modify Customer -Notify -MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Customer-Full/Custpersonal/GUARDIAN |
BIB Contact BC |
Guardian Name |
Not applicable |
Not applicable |
/Customer PartyCredit Profile/Identification /ID |
EL Customer LiabService |
GE-Liability Create-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/LIABLITY NO |
BIB Contact BC |
Liability Number |
BIB Account BC |
Liability Number |
/Customer PartyCredit Profile/CreditLimit Amount |
EL Customer LiabService |
GE-Liability Create-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/OVERALL LIMIT |
BIB Contact BC |
Overall Limit Amount |
BIB Account BC |
Overall Limit Amount |
/Customer PartyCredit Profile /CurrencyCode |
EL Customer LiabService |
GE-Liability Create-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/LIABLITY CCY |
BIB Contact BC |
Limit Currency Code |
BIB Account BC |
Limit Currency Code |
/Customer PartyCredit Profile/TotalUtilized LineOfCredit Amount |
EL Customer LiabService |
GE-Liability Create-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full /UTILISA TIONAMT |
BIB Contact BC |
Total Utilized Amount |
BIB Account BC |
Total Utilized Amount |
/Customer PartyCredit Profile/LastCredit ReviewDate |
EL Customer LiabService |
GE-Liability Create-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/REVISION DATE |
BIB Contact BC |
Revision Date |
BIB Account BC |
Revision Date |
QueryLineOfCreditEBM
The QueryLineOfCreditEBM integration objects, associated with the LineOfCredit EBO, are used in query operations in the Integration to retrieve limit information from Oracle FLEXCUBE Universal Banking. The application mappings used by the QueryLineOfCreditEBM integration objects for the query operation are described in this topic.
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryLineOfCreditEBM
QueryLineOfCreditResponseEBM
Information about the QueryLineOfCreditEBM request-and-response messages is provided in the following topics.
QueryLineOfCreditEBM
The following information lists the mapping information for the QueryLineOfCreditEBM.
Table QueryLineOfCreditEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification /AlternateObject Key/ID |
LSFacilityService |
GE-FacilityExecuteQuery-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Facility-Full/LIABID |
FINS BIB Account FINS BIB Contact |
Liability Number |
/Identification/ID |
LSFacilityService |
GE-FacilityExecuteQuery-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Facility-Full/LINECODE GEM_REQ_ENV/GEM_BODY/Facility-Full/LINESERIAL |
FINS BIB Limit Details |
Line ID |
/Identification/ContextID |
LSFacilityService |
GE-FacilityExecuteQuery-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Facility-Full/LIABBR |
FINS BIB Account FINS BIB Contact |
Branch Code |
QueryLineOfCreditResponseEBM
The following information lists the mapping information for the QueryLineOfCreditResponseEBM.
Table QueryLineOfCreditResponseEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/LINECODE GEM_RES_ENV/GEM_BODY/Facility-Full/LINESERIAL |
FINS BIB Limit Details |
Line ID |
/CurrencyCode |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/LINECCY |
FINS BIB Limit Details |
Line Currency |
/RevolvingIndicator |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/REVOLVINGLINE |
FINS BIB Limit Details |
Revolving Flag |
/Collateralized Indicator |
Not applicable |
Not applicable |
Y If COLLATERALCONTRIBUTION > 0 Else N |
FINS BIB Limit Details |
Secured Flag |
/SanctionedLimit Amount |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/DSPEFFLINE AMOUNT |
FINS BIB Limit Details |
Effective Limit Amount |
/AvailableAmount |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/AVAILABLE AMOUNT |
FINS BIB Limit Details |
Available amount |
/EffectiveTimePeriod/StartDateTime |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/LINESTARTDATE |
FINS BIB Limit Details |
Start Date |
/EffectiveTimePeriod/EndDateTime |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/LINEEXPIRYDATE |
FINS BIB Limit Details |
Expiry Date |
/CustomerParty Reference/PartyIdentification/ID |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
GEM_RES_ENV/GEM_BODY/Facility-Full/LIABID |
FINS BIB Account FINS BIB Contact |
Liability Number |
/ParentLineOfCredit Reference/LineOfCredit Identification/ID |
LSFacilityService |
GE-Facility ExecuteQuery-Res-Full-MSG.xsd |
MAINLINEID derived main line ID from table |
FINS BIB Limit Details |
Main Line Number |
QueryDocumentaryCollectionEBM
The QueryDocumentaryCollectionEBM integration objects, associated with the Documentary Collection EBO, are used in query operations in the Integration to retrieve contract information from Oracle FLEXCUBE Universal Banking - Bills and Collections. The application mappings used by the QueryDocumentaryCollectionEBM integration objects for the query operation are described in this topic.
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryDocumentaryCollectionEBM/DataArea/QueryDocumentaryCollection
QueryDocumentaryCollectionResponseEBM/DataArea/QueryDocumentaryCollectionResponse
Information about the QueryDocumentaryCollectionEBM request-and-response messages is provided in the following topics.
QueryDocumentaryCollectionEBM
The following information lists the mapping information for the QueryDocumentaryCollectionEBM.
Table QueryDocumentaryCollectionEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification /ID |
FCUBSBCService |
BCContract-Query-Req-MSG.xsd |
FCUBS_REQ_ENV/FCBUBS_BODY/BCContract-Query_Req/FCCREF |
FINS BIB Contract |
Contract Reference Num |
/Identification/ContextID |
FCUBSBCService |
BCContract-Query-Req-MSG.xsd |
FCUBS_REQ_ENV/FCBUBS_BODY/BCContract-Query_Req/BRN |
FINS BIB Contract |
Branch Code |
QueryDocumentaryCollectionResponseEBM
The following information lists the mapping information for the QueryDocumentaryCollectionResponseEBM.
Table QueryDocumentaryCollectionResponseEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/FCCREF |
FINS BIB Contract |
Contract Reference Num |
/BookedDate |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/TXNDT |
FINS BIB Contract |
Issue Date |
/EffectiveDate |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/VALDT |
FINS BIB Contract |
Value Date |
/NormalPayment ProcessingDuration |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/REIMBDAYS |
FINS BIB Contract |
Reimbursement Days |
/CurrencyCode |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/BLCCY |
FINS BIB Contract |
Currency Code |
/ContractAmount |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/BLAMT |
FINS BIB Contract |
Contract Amount |
/Outstanding Amount |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/BLDUEAMT |
FINS BIB Contract |
Bill Outstanding Amount |
/Discrepancy Indicator |
Not applicable |
Not applicable |
Y if discrepancy has occurred, else N. |
FINS BIB Contract |
Discrepan- cies Flag |
/PaymentException Indicator |
Not applicable |
Not applicable |
Y If payment exception occurs, else N. |
FINS BIB Contract |
Exceptions Flag |
/OperationType Code |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/OPERATION |
FINS BIB Contract |
Operation Code |
/UsanceTimePeriod /StartDateTime |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/BASEDT |
FINS BIB Contract |
Base Date |
/UsanceTimePeriod /Duration |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/TENORCODE |
FINS BIB Contract |
Tenor |
/Status/Code |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/CONTSTAT |
FINS BIB Contract |
Contract Status |
/InterestSchedule/InterestRate |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/INTRATE |
FINS BIB Contract |
Interest Rate |
/ItemReference/ItemIdentification/ID |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/PRODUCT |
FINS BIB Contract |
Product |
/LineOfCredit Reference/LineOfCredit Identification/Id |
Not applicable |
Not applicable |
Value is derived, based on OURLCREF or THRLCREF. |
FINS BIB Contract |
LC Reference Number |
/Financial InstitutionBranch BusinessUnit Reference/BusinessUnit Identification/ID |
Not applicable |
Not applicable |
Branch Code |
FINS BIB Contract |
Branch Code |
/InterestSchedule/Outstanding InterestAmount |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/AQRDAMT |
FINS BIB Contract |
Interest Accrued |
/UsanceTimePeriod /EndDateTime |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/MATDT |
FINS BIB Contract |
Maturity Date |
/RenewalCount |
Not applicable |
Not applicable |
Number of rollover events fired on this contract |
FINS BIB Contract |
Number Of Rollover |
/LoanAvailed Indicator |
Not applicable |
Not applicable |
Y if contract linkages exists, else N. |
FINS BIB Contract |
Loan Linkage Flag |
Drawee |
|||||
/Documentary CollectionDrawee/Documentary CollectionDrawee PersonParty/Person PartyReference /PersonName/Identification/ID |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Parties-Details/PRTYID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary CollectionDrawee/Documentary CollectionDrawee PersonParty/Person PartyReference/PersonName/FullName |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Parties-Details/PRTYNAME |
FINS BIB Contract Parties VBC |
Party Name |
Not applicable |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Parties-Details/PRTYTYPE |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary CollectionDrawee/Documentary CollectionDrawee PersonParty/Person PartyReference/LocationReference/Address/Country Code |
Not applicable |
Not applicable |
Country code |
FINS BIB Contract Parties VBC |
Party Country |
Drawer |
|||||
/Documentary CollectionDrawer/Documentary CollectionDrawer PersonParty/Person PartyReference/PersonName/Identification/ID |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Parties-Details/PRTYID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary CollectionDrawer /Documentary CollectionDrawer PersonParty/Person PartyReference/PersonName/FullName |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Parties-Details/PRTYNAME |
FINS BIB Contract Parties VBC |
Party Name |
Not applicable |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Parties-Details/PRTYTYPE |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary CollectionDrawer/Documentary CollectionDrawer PersonParty/Person PartyReference/LocationReference/Address/Country Code |
Not applicable |
Not applicable |
Country code |
FINS BIB Contract Parties VBC |
Party Country |
Discrepancy |
|||||
/Documentary Collection Discrepancy/Description |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Discrepancy-Details/DISCDESC |
FINS BIB Contract Discrepancy Details VBC |
Discrepancy Description |
/Documentary Collection Discrepancy/Status /Code |
FCUBSBCService |
BCContract-Query-Res-FULL.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details/Discrepancy-Details/DISCRESFLAG |
FINS BIB Contract Discrepancy Details VBC |
Resolved |
QueryDocumentaryCreditEBM
The QueryDocumentaryCreditEBM integration objects, associated with the Documentary Credit EBO, are used in query operations in the Integration to retrieve contract information from Oracle FLEXCUBE Universal Banking- Letters Of Credit. The application mappings used by the QueryDocumentaryCreditEBM integration objects for the query operation are described in this topic.
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryDocumentaryCreditEBM/DataArea/QueryDocumentaryCredit
QueryDocumentaryCreditEBMResponse/DataArea/QueryDocumentaryCreditResponse
Information about the QueryDocumentaryCreditEBM request-and-response messages is provided in the following topics.
QueryDocumentaryCreditEBM
The following information lists the mapping information for the QueryDocumentaryCreditEBM.
Table QueryDocumentaryCreditEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
FCUBSLCService |
LC-QueryContract-Req-IO-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY /Contract-details-IO/CONREFNO |
FINS BIB Contract |
Contract Reference Num |
/Identification/ContextID |
Not applicable |
Not applicable |
Branch Code (derived) |
FINS BIB Contract |
Branch Code |
QueryDocumentaryCreditResponseEBM
The following information lists the mapping information for the QueryDocumentaryCreditResponseEBM.
Table QueryDocumentaryCreditResponseEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CONREFNO |
FINS BIB Contract |
Contract Reference Num |
/Status/SubStatusCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/OPERCD |
FINS BIB Contract |
Operation Code |
/CurrencyCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CONTCCY |
FINS BIB Contract |
Currency Code |
/Contract Amount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CONTAMT |
FINS BIB Contract |
Contract Amount |
/AvailedAmount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CURRAVAIL |
FINS BIB |
Current Availability |
/Estimated Financial Institution LiabilityAmount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/OSLIAB |
FINS BIB Contract |
Bill Outstand- ing Amount |
/IssueDate |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/ISSDT |
FINS BIB Contract |
Issue Date |
/CloseDate |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CLOSDT |
FINS BIB Contract |
Closure Date |
/EffectiveTime Period/StartDate Time |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/EFFDT |
FINS BIB Contract |
Effective Date |
/EffectiveTime Period/EndDate Time |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/EXPDT |
FINS BIB Contract |
Expiry Date |
/ItemReference /Item Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/PRDCD |
FINS BIB Contract |
Product |
/ItemReference/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/PRDTP |
FINS BIB Contract |
Contract Type |
/ItemReference/Description |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/PRDDESC |
FINS BIB Contract |
Product Descrip- tion |
/Financial Institution BranchBusiness UnitReference/BusinessUnit Identification/ID |
Not applicable |
Not applicable |
Branch Code |
FINS BIB Contract |
Branch Code |
/Status/Code |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/TXNSTAT |
FINS BIB Contract |
Contract Status |
Applicant |
|||||
/CustomerParty Reference /PersonName/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/CustomerParty Reference /PersonName/FullName |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/CustomerParty Reference /Location Reference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/CustomerParty Reference /Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/CustomerParty Reference /Party Identification /ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Advising Bank |
|||||
/Documentary CreditAdvising Financial Institution/Financial Institution Reference/Type Code |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary CreditAdvising Financial Institution/Financial Institution Reference/Organization Name |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Documentary CreditAdvising Financial Institution/Financial Institution Reference/Location Reference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Documentary CreditAdvising Financial Institution /Financial Institution Reference/Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary CreditAdvising Financial Institution/Financial Institution Reference/Party Identification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Applicant’s Bank |
|||||
/Documentary CreditDrawee Financial Institution/Financial Institution Reference/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary CreditDrawee Financial Institution/Financial Institution Reference/Organization Name |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Documentary CreditDrawee Financial Institution/Financial Institution Reference/Location Reference/Address /CountryCode |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Documentary CreditDrawee Financial Institution/Financial Institution Reference/Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary CreditDrawee Financial Institution/Financial Institution Reference/Party Identification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Beneficary |
|||||
/Benificary/BenificaryPersonParty/ PersonParty Reference/PersonName/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Defaulted to Benificary |
/Benificary/BenificaryPersonParty/Person PartyReference/PersonName/FullName |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Benificary/BenificaryPersonParty/Person PartyReference/Location Reference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Benificary/BenificaryPersonParty/Person PartyReference /Party IDentification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Benificary/BenificaryPersonParty/Person PartyReference/Party IDentification /ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Confirming Bank |
|||||
/Documentary CreditConfirmingFinancial Institution/Financial Institution Reference/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary CreditConfirmingFinancial Institution/Financial Institution Reference/Organization Name |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Documentary CreditConfirmingFinancial Institution/Financial Institution Reference/Location Reference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Documentary CreditConfirmingFinancial Institution/Financial Institution Reference/Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary CreditConfirmingFinancial Institution/Financial Institution Reference/Party Identification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Reimbursing Bank |
|||||
/Documentary Credit Reimbursing Financial Institution/Financial Institution Reference/Type Code |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary Credit Reimbursing Financial Institution/Financial Institution Reference/Organization Name |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Documentary Credit Reimbursing Financial Institution/Financial Institution Reference/Location Reference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Documentary Credit Reimbursing Financial Institution/Financial Institution Reference/Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary Credit Reimbursing Financial Institution/Financial Institution Reference/Party Identification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Transferee 1 |
|||||
/Documentary Credit Transferring Financial Institution/Financial Institution Reference/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/Documentary Credit Transferring Financial Institution/Financial Institution Reference/Organization Name |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Documentary Credit Transferring Financial Institution/Financial Institution Reference/Location Reference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Documentary Credit Transferring Financial Institution/Financial Institution Reference/Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Documentary Credit Transferring Financial Institution/Financial Institution Reference/Party Identification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Commissions |
|||||
/Documentary CreditCharge /Charge /Description |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/COMPNT |
FINS BIB Contract Commissions VBC |
Compon- ent Descrip- tion |
/Documentary CreditCharge/ Charge/Amount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/AMT |
FINS BIB Contract Commissions VBC |
Compon- ent Amount |
/Documentary CreditCharge/ Charge/Amount/@CurrencyCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/CCY |
FINS BIB Contract Commissions VBC |
Currency |
/Documentary CreditCharge Charge/Charge/TimePeriod/EndDateTime |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/GOODDATE |
FINS BIB Contract Commissions VBC |
Good Until Date |
Bills and Collections Linkage |
|||||
/Documentary Credit Documentary Collection/Documentary Collection Reference/Documentary Collection Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/BCREFNO |
FINS BIB Contract BC Linkages VBC |
Bill Reference Num |
/Documentary Credit Documentary Collection/Amount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/BILL_AMT |
FINS BIB Contract BC Linkages VBC |
Amount |
/Documentary Credit Documentary Collection/Amount/@CurrencyCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/BCCY |
FINS BIB Contract BC Linkages VBC |
Currency |
Goods Code |
|||||
/Documentary Credit Commodity/Type Code |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Goods-Details/GOODCD |
FINS BIB Contract |
Goods Code or Descrip-tion |
QueryBankGuaranteeEBM
The QueryBankGuaranteeEBM integration objects, associated with the BankGuarantee EBO, are used in query operations in the Integration to retrieve contract information from Oracle FLEXCUBE Universal Banking - Bank Guarantee. The application mappings used by the QueryBankGuaranteeEBM integration objects for the query operation are described in this topic.
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryBankGuaranteeEBM/DataArea/QueryBankGuarantee
QueryBankGuaranteeResponseEBM/DataArea/QueryBankGuaranteeResponse
Information about the QueryBankGuaranteeEBM request-and-response messages is provided in the following topics.
QueryBankGuaranteeEBM
The following information lists the mapping information for the QueryBankGuaranteeEBM.
Table QueryBankGuaranteeEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
FCUBSLCService |
LC-QueryContract-Req-IO-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/CONTRACT-Details-IO/CONREFNO |
FINS BIB Contract |
Contract Reference Num |
/Identification/ContextID |
Not applicable |
Not applicable |
Branch Code |
FINS BIB Contract |
Branch Code |
QueryBankGuaranteeResponseEBM
The following information lists the mapping information for the QueryBankGuaranteeResponseEBM.
Table QueryBankGuaranteeResponseEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CONREFNO |
FINS BIB Contract |
Contract Reference Num |
/Status/SubStatusCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/OPERCD |
FINS BIB Contract |
Operation Code |
/CurrencyCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CONTCCY |
FINS BIB Contract |
Currency Code |
/ContractAmount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CONTAMT |
FINS BIB Contract |
Contract Amount |
/AvailedAmount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CURRAVAIL |
FINS BIB Contract |
Current Availability |
/EstimatedFinancial InstitutionLiability Amount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/OSLIAB |
FINS BIB Contract |
Bill Outstanding Amount |
/IssueDate |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/ISSDT |
FINS BIB Contract |
Issue Date |
/CloseDate |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/CLOSDT |
FINS BIB Contract |
Closure Date |
/EffectiveTime Period/StartDate Time |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/EFFDT |
FINS BIB Contract |
Effective Date |
/EffectiveTime Period/EndDateTime |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/EXPDT |
FINS BIB Contract |
Expiry Date |
/ItemReference/ItemIdentification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/PRDCD |
FINS BIB Contract |
Product |
/ItemReference/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/PRDTP |
FINS BIB Contract |
Contract Type |
/ItemReference/Description |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/PRDDESC |
FINS BIB Contract |
Product Description |
/FinancialInstitution BranchBusinessUnit Reference/Business UnitIdentification/ID |
Not applicable |
Not applicable |
Branch Code |
FINS BIB Contract |
Branch Code |
/Status/Code |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/TXNSTAT |
FINS BIB Contract |
Contract Status |
/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/ISSREQ |
FINS BIB Contract |
Guarantee Type |
/Description |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/GUARNTYP |
FINS BIB Contract |
Guarantee Description |
Applicant |
|||||
/CustomerParty Reference /PersonName/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/CustomerParty Reference/PersonName/FullName |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/CustomerParty Reference/Location Reference/Address/CountryCode |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/CustomerParty Reference/Party Identification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/CustomerParty Reference/Party Identification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Beneficiary |
|||||
/Benificary/Benificary PersonParty/Person PartyReference/PersonName/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/Benificary/Benificary PersonParty/Person PartyReference/PersonName/FullName |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/Benificary/Benificary PersonParty/Person PartyReference/LocationReference/Address/Country Code |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/Benificary/Benificary PersonParty/Person PartyReference/Party IDentification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/Benificary/Benificary PersonParty/Person PartyReference/PartyIDentification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Advising Bank |
|||||
/BankGuarantee AdvisingFinancial Institution/Financial InstitutionReference/TypeCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYDESC FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PRTYTYP |
FINS BIB Contract Parties VBC |
Party Type |
/BankGuarantee AdvisingFinancial Institution/Financial InstitutionReference/OrganizationName |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTNAME |
FINS BIB Contract Parties VBC |
Party Name |
/BankGuarantee AdvisingFinancial Institution/Financial InstitutionReference/LocationReference/ Address/CountryCode |
Not applicable |
Not applicable |
Party Country |
FINS BIB Contract Parties VBC |
Party Country |
/BankGuarantee AdvisingFinancial Institution/Financial InstitutionReference/PartyIDentification/ID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/PARTYCIFID |
FINS BIB Contract Parties VBC |
Party Id |
/BankGuarantee AdvisingFinancial Institution/Financial InstitutionReference/ PartyIDentification/ContextID |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Party-Details/CUSTREFNO |
FINS BIB Contract Parties VBC |
Reference |
Commissions |
|||||
/BankGuarantee Charge/Charge /Description |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/COMPNT |
FINS BIB Contract Commissions VBC |
Component Description |
/BankGuarantee Charge/Charge /Amount |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/AMT |
FINS BIB Contract Commissions VBC |
Component Amount |
/BankGuarantee Charge/Charge /Amount /@CurrencyCode |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/CCY |
FINS BIB Contract Commissions VBC |
Currency |
/BankGuarantee Charge/Charge/Time Period/EndDateTime |
FCUBSLCService |
LC-Query Contract-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Contract-Details-Full/Commission/Commission-Details/GOODDATE |
FINS BIB Contract Commissions VBC |
Good Until Date |
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
The following information lists the mapping information for the QueryMarketingOfferEBM.
Table 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
The following information lists the mapping information for the QueryMarketingOfferResponseEBM.
Table 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 |
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
The following information lists the mapping information for the CreateSalesOpportunityEBM request message.
Table 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 |
ServiceRequestEBM
The ServiceRequestEBM integration objects, associated with the ServiceRequestEBO, are used in create, update and query operations in the Integration. The application mappings used by the ServiceRequestEBM integration objects for each of these operations is provided in the following topics:
CreateServiceRequestEBM
CreateServiceRequestEBM is used to create a service request in Siebel CRM.
Operation
Create
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request and Response Operational Elements
CreateServiceRequestEBM/CreateServiceRequestDataArea/CreateServiceRequest
CreateServiceRequestEBM/CreateServiceRequestDataArea/CreateServiceRequestResponse
Information about the CreateServiceRequestEBM request-and-response messages is provided in the following topics.
CreateServiceRequestEBM
The following information lists the mapping information for the CreateServiceRequestEBM message.
Table CreateServiceRequestEBM
| 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-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SRNO |
Service Request |
SR Number |
/CategoryCode |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SRTYPE |
Service Request |
INS Area |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Service Request |
INS Product |
/Summary |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SUBJECT |
Service Request |
Abstract |
/Description |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/DESCRIPTION |
Service Request |
Descrip- tion |
/PriorityCode |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/PRIORITY |
Service Request |
Priority |
/Status/Code |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/STATUS |
Service Request |
Status |
/CustomerParty Reference/Party Identification/ID |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/CUSTNO |
Service Request |
Not applicable |
/CustomerParty Reference/Party Identification/Application ObjectKey/ID |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/XREF |
Service Request |
Account ID Contact ID |
/CustomerParty Reference/Party Identification/Application ObjectKey/ContextID |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Service Request |
Not applicable |
/CustomerParty Reference/CustomerParty Account Identification/ID |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/CUSTACNO |
Service Request |
Contact Financial Accounts Asset Number |
/ServiceRequest Origination BusinessUnit/ParentBusinessUnitReference/ BusinessUnit Identification/ID |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/BRN |
Service Request |
Branch Code |
/Identification/ID |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SRNO |
Service Request |
SR Number |
/ExpectedClose DateTime |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/TargetDate |
Service Request |
Commit Time |
/CreationDate Time |
Not applicable |
ST-CreateService-Request-Req-IO-MSG.xsd |
FCUBS_CREATESERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/CONTACTDATE |
Service Request |
Create |
CreateServiceRequestResponseEBM
The following information lists the mapping information for the CreateServiceRequestResponseEBM.
Table CreateServiceRequestResponseEBM
| 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 |
/Expected CloseDateTime |
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 |
Create |
UpdateServiceRequestEBM
UpdateServiceRequestEBM is used to update service request data in Siebel CRM.
Operation
Create
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request Operational Element
UpdateServiceRequestEBM/DataArea/UpdateServiceRequest
The following information lists the mapping information for the UpdateServiceRequestEBM request message.
Table UpdateServiceRequestEBM
| 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-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SRNO |
Service Request |
SR Number |
/CategoryCode |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SRTYPE |
Service Request |
INS Area |
/Summary |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/SUBJECT |
Service Request |
Abstract |
/Description |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/DESCRIPTION |
Service Request |
Description |
/PriorityCode |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/PRIORITY |
Service Request |
Priority |
/Status/Code |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/STATUS |
Service Request |
Status |
/CustomerParty Reference/Party Identification/ID |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/CUSTNO |
Service Request |
Not applicable |
/CustomerParty Reference/Party Identification/ApplicationObjectKey/ID |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/XREF |
Service Request |
Account ID Contact ID |
/CustomerParty Reference/Party Identification/ApplicationObjectKey/ContextID |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Service Request |
Not applicable |
/CustomerParty Reference/CustomerParty Account Identification/ID |
Not applicable |
ST-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/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-ModifyService-Request-Req-IO-MSG.xsd |
FCUBS_MODIFYSERVICEREQUEST_REQ/FCUBS_ BODY/BLK_SERVICE_ REQUEST_DETAILS/BRN |
Service Request |
Branch Code |
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
The following information lists the mapping information for the QueryServiceRequestListEBM request message.
Table 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
The following information lists the mapping information for the QueryServiceRequestListResponseEBM.
Table 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 |
CreateCustomerInteractionEBM
The CreateCustomerInteractionEBM integration object, associated with the CustomerInteractionEBO, is used to create an activity in Siebel CRM. The application mappings used by the CreateCustomerInteractionEBM 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
CreateCustomerInteractionEBM/DataArea/CreateCustomerInteraction
The following information lists the mapping information for the CreateCustomerInteractionEBM message.
Table CreateCustomerInteractionEBM
| XML Path | Activity | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|---|
/Description |
Stop Payment |
FCUBS AccService |
CG-NewStop Payment-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Stop-Payments-Full/STOPPAYNO |
Action |
Short Comment |
Cheque Book Request |
Not applicable |
Not applicable |
Value set to Cheque book query |
|||
Standing Instruction |
FCUBS SIService |
SI-New Contract- Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Instruction-Details/PRODDESC |
|||
/StartDate Time |
Stop Payment |
FCUBSAcc Servic |
CG-NewStop Payment-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Stop-Payments-Full/EFFDATE |
Action |
Planned |
Cheque Book Request |
FCUBSAcc Service |
CG-CheckBook-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Check-Book-Full/CHECKERTSTAMP |
|||
Standing Instruction |
FCUBS SIService |
SI-NewContract-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Instruction-Details/FRSTVALDT |
|||
/Customer Party Reference /Person Name /Identifica tion/ID |
Stop Payment |
Not applicable |
Not applicable |
Customer number (Derived, based on Account Number) |
Action |
Not applicable |
Cheque Book Request |
Not applicable |
Not applicable |
Customer number (Derived, based on Account Number) |
|||
Standing Instruction |
Not applicable |
Not applicable |
Customer number (Derived based on Account Number) |
|||
/Customer Party Reference /Person Name /Identifica tion/ApplicationObjectKey /ID |
Stop Payment |
Not applicable |
Not applicable |
XREF (Derived from table) |
Action |
Contact MVL Account Id |
Cheque Book Request |
Not applicable |
Not applicable |
XREF (Derived from table) |
|||
Standing Instruction |
Not applicable |
Not applicable |
XREF (Derived from table) |
|||
/Customer Party Reference /Person Name/Identifica tion/ApplicationObjectKey /ContextID |
Stop Payment |
Not applicable |
Not applicable |
Customer Type Values are I or C (Individual customer, Corporate customer) |
Action |
Not applicable |
Cheque Book Request |
Not applicable |
Not applicable |
Customer Type Values are I or C (Individual customer, Corporate customer) |
|||
Standing Instruction |
Not applicable |
Not applicable |
Customer Type Values are I or C (Individual customer or Corporate customer) |
|||
/Financial Account Reference /Financial Account Identifica tion/ID |
Stop Payment |
FCUBSAcc Servic |
CG-NewStop Payment-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Stop-Payments-Full/ACC |
Action |
Action |
Cheque Book Request |
FCUBSAcc Service |
CG-CheckBook-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Check-Book-Full/ACC |
|||
Standing Instruction |
FCUB SSIService |
SI-NewContract-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Instruction-Details/CRACC FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Instruction-Details/DRACC |
|||
/Customer Interaction Origination Business Unit/Business Unit Reference /Business UnitIdentifi cation/ID |
Stop Payment |
Not applicable |
Not applicable |
Branch Code (Derived from Account Number) |
Not applicable |
Not applicable |
Cheque Book Request |
FCUBSAcc Service |
CG-CheckBook-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Check-Book-Full /BRN |
|||
Standing Instruction |
FCUBS SIService |
SI-NewContract-Notify-MSG.xsd |
FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Instruction-Details /CRACCBRN FCUBS_ NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/Instruction-Details/DRACCBRN |
|||
Not applicable |
Stop Payment |
Not applicable |
Not applicable |
Not applicable |
Action |
Type |
Cheque Book Request |
Not applicable |
|||||
Standing Instruction |
Not applicable |
Not applicable |
Not applicable |
|||
Not applicable |
Stop Payment |
Not applicable |
Not applicable |
Not applicable |
Action |
Status |
Cheque Book Request |
Not applicable |
|||||
Standing Instruction |
Not applicable |
Not applicable |
Not applicable |
Deposit AccountEBM
The Deposit Account EBM integration objects, associated with the Deposit Account EBO, are used in create, update and query operations in the Integration. The application mappings used by the DepositAccountEBM integration objects for each of these operations is provided in the following topics:
CreateDepositAccountEBM
CreateDepositAccountEBM is used to create account links in Siebel CRM.
Operation
Create and Update
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request Operational Element
CreateDepositAccountEBM/DataArea/CreateDepositAccount
The following information lists the mapping information used by the CreateDepositAccountEBM when creating checking and saving accounts (CASA accounts) and term deposit (TD) accounts, and when creating corporate deposit accounts.
Table CreateDepositAccountEBM
| XML Path | Account Type | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|---|
/AccountNumber |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ACC |
FINCORP Account |
Account Number |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/FCCREF |
|||
/FinancialAccount Identification /Application ObjectKey /ContextID |
CASA and TD accounts |
Not applicable |
Not applicable |
Possible values are CA or TD (current or savings account, term deposit) |
FINCORP Account |
Sub Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
CD (corporate deposit) |
|||
/FinancialAccount Financial InstitutionBranchBusinessUnit /Financial InstitutionBranch BusinessUnit Reference/BusinessUnit Identification/ID |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/BRN |
FINCORP BIB Account |
Branch Code |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/BRN |
|||
/CurrencyCode |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/CCY |
FINCORP Account |
Currency |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/CCY |
|||
/Financial AccountHolder /FinancialAccount PersonHolder /PersonParty Reference/ /PersonName/Identification/ ApplicationObjectKey/ID |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/XREF |
FINCORP Account |
Organiza-tion Id |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/XREF |
|||
/Financial AccountHolder /FinancialAccount PersonHolder /PersonParty Reference/ /PersonName/Identification/ID |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/CUSTNO |
Not applicable |
Not applicable |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/CPTY |
|||
/Financial AccountHolder /FinancialAccount PersonHolder /PersonParty Reference/ /PersonName/Identification/ ApplicationObjectKey/ID |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/XREF |
FINCORP Account |
Acct Gen - Authorized Users - Last Name |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/XREF |
|||
/Financial AccountHolder/FinancialAccount PersonHolder/PersonParty Reference/ /PersonName/Identification/ ApplicationObjectKey/ContextID |
CASA and TD accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Not applicable |
Not applicable |
Corporate deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
|||
/Description |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ADESC |
FINCORP Account |
Comments |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/TDESC |
|||
/Status/Code |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ACCSTAT |
FINCORP Account |
Account Status |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/UDSTAT |
|||
/BalanceAmount |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_CURR_ BALANCE |
FINCORP Account |
Current Balance |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/Available BalanceAmount |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_AVL_BAL |
FINCORP Account |
Available Balance |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/Uncleared BalanceAmount |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_ UNCOLLECTE |
FINCORP BIB Account |
Uncollected Fund Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/BlockedBalance Amount |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_ BLOCKED_AMOUNT |
FINCORP BIB Account |
Blocked Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/CreditInterest AccrualAmount |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_ ACCRUED_CR_IC |
FINCORP BIB Account |
Accrued Interest |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/TypeCode |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ACCLS |
FINCORP Account |
Name |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/PRD |
|||
/InitialCredit Amount |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/TDAMT |
FINCORP BIB Account |
Principal Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
||||
/MaturityDate |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/MATDT |
FINCORP Account |
Maturity Date |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/MATDT |
|||
/Status/SubStatusCode |
CASA and TD accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Contract Status |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/CONTSTAT |
|||
/DepositAccount InterestSchedule /Interest Schedule/InterestRate |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/RATE |
FINCORP Account |
Interest Rate |
Corporate deposit accounts |
FCUBSLD Service |
LD-NewContract-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Contract-Master/RATE |
|||
/DepositAccount Interest Schedule/InterestSchedule /EffectiveTime Period/StartDate Time |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/INTSTDT |
FINCORP Account |
Start Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Interest Schedule/InterestSchedule /EffectiveTime Period/Duration |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/DEPTENOR |
FINCORP Account |
Term |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/ItemReference/TypeCode |
CASA and TD accounts |
FCUBSAcc Service |
CA-NewCustomer Account-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDACC |
FINCORP BIB Account |
Recurring Deposit Account Flag |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/Financial AccountHolder /FinancialAccount PersonHolder /PersonParty Reference/ /PersonName /TypeCode |
CASA and TD accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
FINCORP Account Contact |
Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
UpdateDepositAccountEBM
UpdateDepositAccountEBM is used to:
Update a demand deposit account with a new title in Siebel CRM
Delete the title of a demand deposit account in Siebel CRM
Update an account branch code in Siebel CRM
Operation
Update
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request Operational Element
UpdateDepositAccountEBM/DataArea/UpdateDepositAccount
The following information lists the mapping information used by the UpdateDepositAccountEBM when checking and saving accounts (CASA accounts) and term deposit accounts are updated.
Table UpdateDepositAccountEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/AccountNumber |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ACC |
FINCORP Account |
Account Number |
/FinancialAccountIdentification /ApplicationObjectKey/ContextID |
Not applicable |
Not applicable |
Possible values are CA,TD, CD (Current or savings account, term deposit, corporate deposit) |
FINCORP Account |
Sub Type |
/FinancialAccountFinancial InstitutionBranchBusinessUnit /FinancialInstitutionBranch BusinessUnitReference /BusinessUnitIdentification/ID |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/BRN |
FINCORP BIB Account |
Branch Code |
/CurrencyCode |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/CCY |
FINCORP Account |
Currency |
/FinancialAccountHolder/ FinancialAccountPersonHolder/ PersonPartyReference/ /PersonName/Identification/ ApplicationObjectKey/ID |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/XREF |
FINCORP Account |
Organiza-tion Id |
/FinancialAccountHolder/ FinancialAccountPersonHolder /PersonPartyReference //PersonName/Identification /ID |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/CUSTNO |
Not applicable |
Not applicable |
/FinancialAccountHolder/ FinancialAccountPersonHolder/ PersonPartyReference/ /PersonName/Identification/ ApplicationObjectKey/ID |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/XREF |
FINCORP Account |
Acct Gen - Authorized Users - Last Name |
/FinancialAccountHolder/ FinancialAccountPersonHolder/ PersonPartyReference/ /PersonName/Identification/ ApplicationObjectKey/ ContextID |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Not applicable |
Not applicable |
/Description |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ADESC |
FINCORP Account |
Comments |
/Status/Code |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ACCSTAT |
FINCORP Account |
Account Status |
/BalanceAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_CURR_ BALANCE |
FINCORP Account |
Current Balance |
/AvailableBalanceAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_AVL_BAL |
FINCORP Account |
Available Balance |
/UnclearedBalanceAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_ UNCOLLECTE |
FINCORP BIB Account |
Uncollect-ed Fund Amount |
/BlockedBalanceAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_BLOCKED_AMOUNT |
FINCORP BIB Account |
Blocked Amount |
/CreditInterestAccrualAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_ACCRUED_CR_IC |
FINCORP BIB Account |
Accrued Interest |
/TypeCode |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/ACCLS |
FINCORP Account |
Name |
/InitialCreditAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/TDAMT |
FINCORP BIB Account |
Principal Amount |
/MaturityDate |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/MATDT |
FINCORP Account |
Maturity Date |
/Status/SubStatusCode |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Contract Status |
/DepositAccountInterest Schedule/InterestSchedule/InterestRate |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/RATE |
FINCORP Account |
Interest Rate |
/DepositAccountInterest Schedule/InterestSchedule/ EffectiveTimePeriod/ StartDateTime |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/INTSTDT |
FINCORP Account |
Start Date |
/DepositAccountInterest Schedule/InterestSchedule/ EffectiveTimePeriod/Duration |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/DEPTENOR |
FINCORP Account |
Term |
/ItemReference/TypeCode |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDACC |
FINCORP BIB Account |
Recurring Deposit Account Flag |
/FinancialAccountHolder/ FinancialAccountPersonHolder /PersonPartyReference/ /PersonName/TypeCode |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Not applicable |
Type |
/DebitInterestAccrualAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Amount-Dates/ACY_ACCRUED_DR_IC |
FINCORP BIB Account |
Accrued Interest |
/DepositAccountOverdraft/ SanctionedLimitAmount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/TODLIMIT |
FINCORP BIB Account |
Temporary Limit Amount |
/DepositAccountOverdraft /DepositAccountOverdraftLine OfCredit/LineOfCreditReference/ LineOfCreditIdentification/ID |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/LINEID |
FINCORP BIB Account |
Credit Line Number |
/DepositAccountOverdraft/ EffectiveTimePeriod/ StartDateTime |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/TODLIMSTDT |
FINCORP BIB Account |
Temporary Overdraft Start Date |
/DepositAccountOverdraft/ EffectiveTimePeriod/ EndDateTime |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/TODLIMENDT |
FINCORP BIB Account |
Temporary Overdraft End Date |
/DebitAllowedIndicator |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/ACSTATNODR |
FINCORP BIB Account |
Debit Flag |
/CreditAllowedIndicator |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/ACSTATNOCR |
FINCORP BIB Account |
Credit Flag |
/CheckStopPayment PendingIndicator |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/ACSTATSTPAY |
FINCORP BIB Account |
Stop Payment Flag |
/DormantIndicator |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/DORM |
FINCORP Account |
Account Status |
/FrozenIndicator |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/FROZEN |
FINCORP BIB Account |
Frozen Flag |
/LastStatementDate |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/PREVSTMTDT |
FINCORP Account |
CA Last Statement Date |
/LastStatementBalance Amount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/PREVSTMTBAL |
FINCORP BIB Account |
Last Statement Balance |
/DepositAccountRelatedParty /DepositAccountRelated PersonParty/ PersonPartyReference /PersonName/FullName |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/NOM1 |
FINCORP BIB Account |
First Nominee |
/DepositAccountRelatedParty/ DepositAccountRelatedPerson Party/PersonPartyReference /PersonName/FullName |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Cust-Account/NOM2 |
FINCORP BIB Account |
Second Nominee |
/DepositAccountRelatedParty /DepositAccountRelatedPerson Party/PersonPartyReference /PersonName/TypeCode |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Not applicable |
Not applicable |
/BookedDate |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Book Date |
/EffectiveDate |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Value Date |
/RenewalCount |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Number of Times Rollover |
/DepositAccountTransaction Schedule/FinancialTransactionSchedule/ CycleDayIncrement |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDFREDAY |
FINCORP BIB Account |
Not applicable |
/DepositAccountTransaction Schedule/FinancialTransactionSchedule/ CycleMonthIncrement |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDFREMTH |
FINCORP BIB Account |
Not applicable |
/DepositAccountTransaction Schedule/FinancialTransactionSchedule/ CycleYearIncrement |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDFREYEAR |
FINCORP BIB Account |
Not applicable |
/DepositAccountTransaction Schedule/FinancialTransactionSchedule /FinancialTransaction ScheduleLine/Amount |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDAMT |
FINCORP BIB Account |
Install- ment Amount |
/DepositAccountTransaction Schedule/FinancialTransactionSchedule/ NextTransactionDate |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDPAYSCHDT |
FINCORP BIB Account |
Payment date |
/DepositAccountTransaction Schedule/FinancialTransactionSchedule /FinancialTransactionSchedule Line/FinancialAccount/CurrencyCode |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/RDPAYMNTCCY |
FINCORP BIB Account |
Payment Currency |
/DepositAccountTransaction Schedule/FinancialTransaction Schedule/FinancialTransaction ScheduleLine/FinancialAccount /AccountNumber |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/PAYACC |
FINCORP BIB Account |
Payment Account |
/DepositAccountTransaction Schedule/FinancialTransaction Schedule/FinancialTransaction ScheduleLine/FinancialAccount /FinancialAccountFinancial InstitutionBranchBusinessUnit /FinancialInstitutionBranch BusinessUnitReference/ BusinessUnitIdentification/Id |
FCUBS AccService |
CA-Modify CustomerAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_IDENTIFIER/Cust-Account-Full/Tddetails/PAYBRN |
FINCORP BIB Account |
Payment Branch |
QueryDepositAccountEBM
QueryDepositAccountEBM is used to:
Retrieve financial account information from Oracle FLEXCUBE Universal Banking
Retrieve standing instruction information from Oracle FLEXCUBE Universal Banking
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryDepositAccountEBM/DataArea/QueryDepositAccount
QueryDepositAccountResponseEBM/DataArea/QueryDepositAccountResponse
Information about the QueryDepositAccountEBM request-and-response messages is provided in the following topics.
QueryDepositAccountEBM
The following information lists the mapping information for the QueryDepositAccountEBM when checking and saving accounts (CASA accounts), term deposit accounts, and corporate deposit accounts are updated.
Table QueryDepositAccountEBM
| XML Path | Account Type | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|---|
/Identification /ID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Req-IO-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Cust-Account-IO/ACC |
FINCORP Account |
Account Number |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Req-IO-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Contract-Master-IO/FCCREF |
|||
/Identification /ContextID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Req-IO-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Cust-Account-IO/BRN |
BIB FINCORP Account |
Field Based on LOC Branch |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Req-IO-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Contract-Master-IO/BRN |
|||
/Identification /Application ObjectKey/ContextID |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Values are CA or TD (CASA account or term deposit account) |
Sub Type |
DTYPE_ TEXT |
Corporate deposit accounts |
Not applicable |
Not applicable |
Value is CD (corporate deposit) |
QueryDepositAccountResponseEBM
The following information lists the mapping information for the QueryDepositAccountResponseEBM when checking and saving accounts (CASA accounts), term deposit (TD) accounts, and corporate deposit (CD) accounts are updated.
Table QueryDepositAccountResponseEBM
| XML Path | Account Type | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Compon-ent | Siebel Contact Field |
|---|---|---|---|---|---|---|
/AccountNumber |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-Query CustAcc-Res- Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/ACC |
FINCORP Account |
Account Number |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loans and Deposits-Full-Type/FCCREF |
|||
/FinancialAccount Identification /ApplicationObject Key/ContextID |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Values are CA, TD, CD (Current or savings account, term deposit, corporate deposit) |
FINCORP Account |
Sub Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
Values are CA, TD, CD (Current or savings account, term deposit, corporate deposit) |
|||
/FinancialAccount Financial InstitutionBranch BusinessUnit/FinancialInstitution BranchBusinessUnit Reference/BusinessUnit Identification/ID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/BRN |
FINCORP BIB Account |
Field based on LOC Branch |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/LoansandDeposits-Full-Type/BRN |
|||
/CurrencyCode |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/CCY |
FINCORP Account |
Currency |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/LoansandDeposits-Full-Type/CCY |
|||
/FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Person Name/Identification /ApplicationObject Key/ID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/XREF |
FINCORP Account |
Organizat-ion Id |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/LoansandDeposits-Full-Type/XREF |
|||
/FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/PersonName /Identification/ID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/CUSTNO |
Not applicable |
Not applicable |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/LoansandDeposits-Full-Type/CPTY |
|||
/FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Person Name/Identification /ApplicationObject Key/ID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/XREF |
FINCORP Account |
Acct Gen- Authorized Users - Last Name |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/LoansandDeposits-Full-Type/XREF |
|||
/FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Person Name/Identification /ApplicationObject Key/ContextID |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Not applicable |
Not applicable |
Corporate deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
|||
/Description |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/ADESC |
FINCORP Account |
Comments |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loans and Deposits-Full-Type/TDESC |
|||
/Status/Code |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/ACCSTAT |
FINCORP Account |
Account Status |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loans and Deposits-Full-Type/UDSTAT |
|||
/BalanceAmount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Amount-Dates/ACY_ CURR_BALANCE |
FINCORP Account |
Current Balance |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/AvailableBalance Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Amount-Dates/ACY_AVL_BAL |
FINCORP Account |
Available Balance |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/UnclearedBalance Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Amount-Dates/ACY_ UNCOLLECTE |
FINCORP BIB Account |
Uncollect-ed Fund Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/BlockedBalance Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Amount-Dates/ACY_ BLOCKED_ AMOUNT |
FINCORP BIB Account |
Blocked Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/CreditInterest AccrualAmount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Amount-Dates/ACY_ ACCRUED_CR_IC |
FINCORP BIB Account |
Accrued Interest |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/TypeCode |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/ACCLS |
FINCORP Account |
Name |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/LoansandDeposits-Full-Type/PRD |
|||
/InitialCredit Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/TDAMT |
FINCORP BIB Account |
Principal Amount |
Corporate deposit accounts |
FCUBSLD Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/TDAMT |
|||
/MaturityDate |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/MATDT |
FINCORP Account |
Maturity Date |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loansand Deposits-Full-Type/MATDT |
|||
/Status/SubStatusCode |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Contract Status |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loansand Deposits-Full-Type/CONTSTAT |
|||
/DepositAccount InterestSchedule/InterestSchedule /InterestRate |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/RATE |
FINCORP Account |
Interest Rate |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loansand Deposits-Full-Type/RATE |
|||
/DepositAccount InterestSchedule/InterestSchedule /EffectiveTime Period/StartDateTime |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/INTSTDT |
FINCORP Account |
Start Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount InterestSchedule/InterestSchedule /EffectiveTime Period/Duration |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/DEPTENOR |
FINCORP Account |
Term |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/ItemReference/TypeCode |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDACC |
FINCORP BIB Account |
Recurring Deposit Account Flag |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/FinancialAccount Holder/FinancialAccount PersonHolder/PersonParty Reference/PersonName/TypeCode |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
FINCORP Account Contact |
Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
|||
/DebitInterest AccrualAmount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Amount-Dates/ACY_ ACCRUED_ DR_IC |
FINCORP BIB Account |
Accrued Interest |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Overdraft/SanctionedLimit Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/TODLIMIT |
FINCORP BIB Account |
Temporary Limit Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Overdraft/Deposit AccountOverdraft LineOfCredit/Line OfCreditReference/LineOfCredit Identification/ID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/LINEID |
FINCORP BIB Account |
Credit Line Number |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Overdraft/Effective TimePeriod/StartDateTime |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/TODLIMSTDT |
FINCORP BIB Account |
Temporary Overdraft Start Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Overdraft/Effective TimePeriod/End DateTime |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/TODLIMENDT |
FINCORP BIB Account |
Temporary Overdraft End Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DebitAllowed Indicator |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/ACSTATNODR |
FINCORP BIB Account |
Debit Flag |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/CreditAllowed Indicator |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/ACSTATNOCR |
FINCORP BIB Account |
Credit Flag |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/CheckStop PaymentPending Indicator |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/ACSTATSTPAY |
FINCORP BIB Account |
Stop Payment Flag |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DormantIndicator |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/DORM |
FINCORP Account |
Account Status |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/FrozenIndicator |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/FROZEN |
FINCORP BIB Account |
Frozen Flag |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/LastStatement Date |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/PREVSTMTDT |
FINCORP Account |
CA Last Statement Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/LastStatement BalanceAmount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/PREVSTMTBAL |
FINCORP BIB Account |
Last Statement Balance |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount RelatedParty/DepositAccount RelatedPerson Party/PersonParty Reference/Person Name/FullName |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/NOM1 |
FINCORP BIB Account |
First Nominee |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount RelatedParty/DepositAccount RelatedPerson Party/PersonParty Reference/Person Name/FullName |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Cust-Account/NOM2 |
FINCORP BIB Account |
Second Nominee |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount RelatedParty/DepositAccount RelatedPersonParty/PersonParty Reference/Person Name/TypeCode |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
Not applicable |
Not applicable |
Corporate deposit accounts |
Not applicable |
Not applicable |
Values are I or C (Individual customer, Corporate customer) |
|||
/BookedDate |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Book Date |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loansand Deposits-Full-Type/BOOKDT |
|||
/EffectiveDate |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Value Date |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Loansand Deposits-Full-Type/VALDT |
|||
/RenewalCount |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account |
Number of Times Rollover |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
Rollover count (DERIVED) |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/CycleDayIncrement |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDFREDAY |
Not applicable |
Not applicable |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Cycle MonthIncrement |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDFREMTH |
Not applicable |
Not applicable |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Cycle YearIncrement |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDFREYEAR |
Not applicable |
Not applicable |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule /Financial Transaction Schedule/Financial Transaction Schedule Line/Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDAMT |
FINCORP BIB Account |
Install- ment Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Next TransactionDate |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDPAYSCHDT |
FINCORP BIB Account |
Payment date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount EBO/Deposit AccountTransaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ CurrencyCode |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/RDPAYMNTCCY |
FINCORP BIB Account |
Payment Currency |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ AccountNumber |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/PAYACC |
FINCORP BIB Account |
Payment Account |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine /FinancialAccount/FinancialAccount FinancialInstitutionBranchBusiness Unit/Financial InstitutionBranch BusinessUnit Reference/Business UnitIdentification/Id |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/PAYBRN |
FINCORP BIB Account |
Payment Branch |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
CASA - Standing Instructions |
||||||
/DepositAccount EBO/Deposit AccountTransaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount /Financial Institution Reference/Location Reference/Name |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
Branch Code (DERIVED) |
FINCORP BIB Account Standing Instructions VBC |
Branch Code |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Identification/ID |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY /SISumDtls-Res-Full/Si-Instruction-Details/INSTRUCTION_ NO |
FINCORP BIB Account Standing Instructions VBC |
Instruct- ion Num |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Next TransactionDate |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY /SISumDtls-Res-Full/Si-Instruction-Details/NEXT_ EXEC_DATE |
FINCORP BIB Account Standing Instructions VBC |
Next Due Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Status/EffectiveEndDate Time |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/SI_EXPIRY_DATE |
FINCORP BIB Account Standing Instructions VBC |
Expiry Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction Schedule Line/Financial Account /CurrencyCode |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/SI_AMT_CCY |
FINCORP BIB Account Standing Instructions VBC |
Currency |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/Amount |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/SI_AMT |
FINCORP BIB Account Standing Instructions VBC |
Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/CycleDayIncrement |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/EXEC_DAYS |
FINCORP BIB Account Standing Instructions VBC |
Execution Days |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Cycle MonthIncrement |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/EXEC_MTHS |
FINCORP BIB Account Standing Instructions VBC |
Execution Months |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/CycleYear Increment |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/EXEC_YRS |
FINCORP BIB Account Standing Instructions VBC |
Execution Years |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Status/Code |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/INST_STATUS |
FINCORP BIB Account Standing Instructions VBC |
Execution Status |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/EffectiveTimePeriod /StartDateTime |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/FIRST_ EXEC_DATE |
FINCORP BIB Account Standing Instructions VBC |
First Execution date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount EBO/Deposit AccountTransaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ AccountNumber |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/CR_ACCOUNT |
FINCORP BIB Account Standing Instructions VBC |
Credit Account |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Transaction Schedule /Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ FinancialAccount FinancialInstitution BranchBusinessUnit/Financial InstitutionBranch BusinessUnit Reference/Business UnitIdentification/Id |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-SISumDtls-Res-Full.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SISumDtls-Res-Full/Si-Instruction-Details/CR_ACC_BR |
FINCORP BIB Account Standing Instructions VBC |
Credit Branch |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
Current and Savings Account and Retail Deposit - Signatories |
||||||
/FinancialAccount Holder/SignatureID |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Accsigdetails/SIGID |
FINCORP BIB Account Signatories VBC |
Signatory Number |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/PersonName |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Accsigdetails/SIGNAME |
FINCORP BIB Account Signatories VBC |
Signatory Name |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/FinancialAccount Holder/Financial AccountSigning Authority/TypeCode |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Accsigdetails/SIGTYPE |
FINCORP BIB Account Signatories VBC |
Signatory Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/FinancialAccount Holder/Financial AccountSigning Authority/Limit Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Accsigdetails/APPROVLIMIT |
FINCORP BIB Account Signatories VBC |
Approval Limit |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/FinancialAccount Holder/Signature Note/Content |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Accsigdetails/SIGMSG |
FINCORP BIB Account Signatories VBC |
Signatory Message |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
Retail Deposit - Redemption |
||||||
/DepositAccount Redemption /RedemptionDate |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/EFFDATE |
FINCORP BIB Account Redemption Detail VBC |
Redempt-ion Date |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
/DepositAccount Redemption /Amount |
CASA and term deposit accounts |
FCUBSAcc Service |
ST-QueryCust Acc-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Tddetails/REDEMPTION_ AMT |
FINCORP BIB Account Redemption Detail VBC |
Redempt-ion Amount |
Corporate deposit accounts |
Not applicable |
Not applicable |
Not applicable |
|||
Corporate Deposit - Schedules |
||||||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/TypeCode |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Schedule Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
Possible values are P or S (Payment and Collection, Standing Instruction) |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule /Description |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Compon-ent Descript-ion |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Contract-Schedules/SCOMP |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/ComponentType Code |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Compon-ent Type |
Corporate deposit accounts |
Not applicable |
Not applicable |
Possible values are P or S (Principal component, Schedule component) |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule /EffectiveTime Period/StartDate Time |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Start Date |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Contract-Schedules/VALDT |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Remaining Scheduled TransactionCount |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Number |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Contract-Schedules/NO_OF_SCHD |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule /FrequencyValue |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Frequency |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Contract-Schedules/FREQ |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/FrequencyUnitCode |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Units |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Contract-Schedules/FREQ_UNIT |
|||
/DepositAccount EBO/Deposit AccountTransaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/Amount |
CASA and term deposit accounts |
Not applicable |
Not applicable |
Not applicable |
FINCORP BIB Account Corporate Deposit Schedule VBC |
Amount Due |
Corporate deposit accounts |
FCUBSLD Service |
LDContract-Query-Res-Full-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Cust-Account-Full/Contract-Schedules/AMT |
|||
CASA - Payments and Collection |
||||||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleID |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/INSTR_REF_NO |
FINCORP BIB Account Payments Collections VBC |
Instrum-ent Reference Number |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/INSTR_REF_NO |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount /ItemReference/Name |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/PRODUCT_CODE |
FINCORP BIB Account Payments Collections VBC |
Product Code |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/PRODUCT_CODE |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ ItemReference /TypeCode |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/PROD_ CATEGORY |
FINCORP BIB Account Payments Collections VBC |
Product Category |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/PROD_ CATEGORY |
|||
/DepositAccount EBO/Deposit AccountTransaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ FinancialInstitution Reference/Location Reference/Name |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_AC_BRN |
FINCORP BIB Account Payments Collections VBC |
Customer Account Branch |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_AC_BRN |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Contact/PersonName/ Identification/ID |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_AC_NO |
FINCORP BIB Account Payments Collections VBC |
Customer Account Number |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_AC_NO |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ CurrencyCode |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_AC_CCY |
FINCORP BIB Account Payments Collections VBC |
Customer Account Currency |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_AC_CCY |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/FinancialAccount/ FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Contact/ PersonName/FullName |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_NO |
FINCORP BIB Account Payments Collections VBC |
Customer Number |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CUST_NO |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine /FinancialAccount/AccountNumber |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CPTY_AC_NO |
FINCORP BIB Account Payments Collections VBC |
Counter Party Account Number |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CPTY_AC_NO |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Next TransactionDate |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/NEXT_GEN_DT |
FINCORP BIB Account Payments Collections VBC |
Next Generat-ion Date |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/NEXT_GEN_DT |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/CycleDayIncrement |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/EXEC_DAYS |
FINCORP BIB Account Payments Collections VBC |
Execution Days |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/EXEC_DAYS |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Cycle MonthIncrement |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/EXEC_MTHS |
FINCORP BIB Account Payments Collections VBC |
Execution Months |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/EXEC_MTHS |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Cycle YearIncrement |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/EXEC_YRS |
FINCORP BIB Account Payments Collections VBC |
Execution Years |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/EXEC_YRS |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Effective TimePeriod/EndDateTime |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/END_DATE |
FINCORP BIB Account Payments Collections VBC |
End Date |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/END_DATE |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine /FinancialAccount/ FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Person Name/FullName |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CPTY_NAME |
FINCORP BIB Account Payments Collections VBC |
Counter Party Name |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/CPTY_NAME |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/ Amount@CurrencyCode |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/TXN_CCY |
FINCORP BIB Account Payments Collections VBC |
Transact-ion Currency |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/TXN_CCY |
|||
/DepositAccount Transaction Schedule/Financial Transaction Schedule/Financial Transaction ScheduleLine/Amount |
CASA and term deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/TXN_AMOUNT |
FINCORP BIB Account Payments Collections VBC |
Transact-ion Amount |
Corporate deposit accounts |
FCUBSSCV Service |
SCV-PCMaint SumDtls-Res.xsd |
FCUBS_RES_ENV/FCUBS_BODY/PCMaintSumDtls-Res/Pc-Instruction-Details/TXN_AMOUNT |
|||
QueryFinancialTransactionListEBM
The QueryFinancialTransactionListEBM integration objects, associated with the Financial Transaction EBO, are used in query operations in the Integration to retrieve financial transactions from Oracle FLEXCUBE Universal Banking. The application mappings used by the QueryFinancialTransactionListEBM integration objects for the query operation are provided in this topic.
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryFinancialTransactionListEBM/DataArea/Query/QueryCriteria/QueryExpression/ValueExpression/
QueryFinancialTransactionListResponseEBM/DataArea/QueryFinancialTransactionListResponse
Information about the QueryFinancialTransactionListEBM request-and-response messages is provided in the following topics.
QueryFinancialTransactionListEBM
The following information lists the mapping information for the QueryFinancialTransactionListEBM.
Table QueryFinancialTransactionListEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
Element Path = "Account Number" Element Value = <Value> |
FCUBSSCVService |
SCV-CADtls-Query-Req-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Accsigdetails/AC_NO |
FINCORP BIB Account Transactions VBC |
Account Number |
Element Path = "Branch" Element Value = <Value> |
FCUBSSCVService |
SCV-CADtls-Query-Req-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Accsigdetails/AC_BRANCH |
FINCORP BIB Account Transactions VBC |
Branch |
Element Path = "From Date" Element Value = <Value> |
FCUBSSCVService |
SCV-CADtls-Query-Req-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Accsigdetails/TRN_DT |
FINCORP BIB Account Transaction Query |
Start Date |
Element Path = "To Date" Element Value = <Value> |
FCUBSSCVService |
SCV-CADtls-Query-Req-MSG.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Accsigdetails/TRN_DT |
FINCORP BIB Account Transaction Query |
End Date |
QueryFinancialTransactionListResponseEBM
The following information lists the mapping information for the QueryFinancialTransactionListResponseEBM.
Table QueryFinancialTransactionListResponseEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/SourceFinancial Account/Account Number |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /AC_NO |
FINCORP BIB Account Transactions VBC |
Account Number |
/Identification/Id |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /TRN_REF_NO |
FINCORP BIB Account Transactions VBC |
Transaction Reference Num |
/OriginatedDate Time |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /TRN_DT |
FINCORP BIB Account Transactions VBC |
Transaction Date |
/Destination FinancialAccount/AccountNumber |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /AC_NO |
FINCORP BIB Account Transactions VBC |
Related Account Number |
/PostedDateTime |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /VALUE_DT |
FINCORP BIB Account Transactions VBC |
Value Date |
/TypeCode |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /MODULE |
FINCORP BIB Account Transactions VBC |
Module |
/Description |
Not applicable |
Not applicable |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /TRN_DESC |
FINCORP BIB Account Transactions VBC |
Transaction Code Description |
/Note/Content |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /ADDL_TXT |
FINCORP BIB Account Transactions VBC |
Additional Text |
/PurposeCode |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res/EVENT |
FINCORP BIB Account Transactions VBC |
Event Code |
/OperationTypeCode |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res/DRCR_IND |
FINCORP BIB Account Transactions VBC |
Debit/Credit |
/ConvertedAmount/@currencyCode |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /FCY_CURRENCY |
FINCORP BIB Account Transactions VBC |
Foreign Currency |
/ConvertedAmount |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /FCY_AMOUNT |
FINCORP BIB Account Transactions VBC |
Foreign Currency Amount |
/CurrencyExchange/ConversionRate |
FCUBSSCVService |
SCV-CADtls-Query-Res-MSG.xsd |
FCUBS_RES_ENV/FCUBS_BODY/SCV-CADtls-Query-Res /EXCH_RATE |
FINCORP BIB Account Transactions VBC |
Exchange Rate |
Loan Account EBM
The LoanAccountEBM integration objects, associated with the Loan Account EBO, are used in create, update and query operations in the Integration. The application mappings used by the LoanAccountEBM integration objects for each of these operations is provided in the following topics:
CreateLoanAccountEBM
CreateLoanAccountEBM is used to create account links in Siebel CRM.
Operation
Create
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request Operational Element
CreateLoanAccountEBM/DataArea/CreateLoanAccount
The following information lists the mapping information for the CreateLoanAccountEBM.
Table CreateLoanAccountEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/AccountNumber |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_ NOTIF_ IDENTIFIER /CLACCOUNT SUMMARYRES FULL/ACCNO |
FINCORP Account |
Account Number |
/FinancialAccount Identification/ApplicationObjectKey/ ContextID |
Not applicable |
Not applicable |
Value provided is CL |
FINCORP Account |
Sub Type |
/FinancialAccount FinancialInstitution BranchBusinessUnit /FinancialAccount FinancialInstitution BranchBusiness UnitReference/BusinessUnit Identification/ID |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/BRN |
FINCORP BIB Account |
Branch Code |
/CurrencyCode |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/CCY |
FINCORP Account |
Currency |
/FinancialAccount Holder/Financial AccountPersonHolder/ PersonPartyReference /PartyIdentification /ID |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/CPTY |
FINCORP Account |
Not applicable |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonParty Reference/Party Identification/ApplicationObjectKey/ID |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/XREF |
FINCORP Account |
Organizat-ion Id Acct Gen - Authorized Users - Last Name |
/FinancialAccount Holder/Financial AccountPerson Holder/PersonParty Reference/Party Identification/ApplicationObjectKey /ContextID |
Not applicable |
Not applicable |
Values are I or C (Individual customer or Corporate customer) |
FINCORP Account |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
FINCORP Account |
Acct Gen - Primary Contact Id |
/Status/Code |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/ACCSTAT |
FINCORP Account |
Account Status |
/ItemReference/ItemIdentification/ID |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/PRD |
FINCORP Account |
Name |
/MaturityDate |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/MATDT |
FINCORP Account |
Maturity Date |
/FinancialAccount Holder/Financial AccountSigning Authority/TypeCode |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/OTAPPDET/RESP |
FINCORP Account Contact |
Type |
/LoanAmount |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/OTAPPDET/AMOUNT |
FINCORP Account |
Loan Amount |
/DisbursedAmount |
FCUBSCLService |
CL-NewAccount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARYRESFULL/OTAPPDET/DISBAMT |
FINCORP BIB Account |
Amount Disbursed |
UpdateLoanAccountEBM
UpdateLoanAccountEBM is used to update a home loan account with a new customer ID in Siebel CRM.
Operation
Update
Service Consumer
Oracle FLEXCUBE Universal Banking
Service Provider
Siebel CRM
EBM Request Operational Element
UpdateLoanAccountEBM/DataArea/UpdateLoanAccount
The following information lists the mapping information for the UpdateLoanAccountEBM.
Table UpdateLoanAccountEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/AccountNumber |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/ACCNO |
FINCORP Account |
Account Number |
/FinancialAccount Identification/ApplicationObjectKey /ContextID |
Not applicable |
Not applicable |
Value provided is CL |
FINCORP Account |
Sub Type |
/FinancialAccount FinancialInstitution BranchBusinessUnit /FinancialAccount FinancialInstitution BranchBusinessUnit Reference/Business UnitIdentification /ID |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/BRN |
FINCORP BIB Account |
Branch Code |
/CurrencyCode |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/CCY |
FINCORP Account |
Currency |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference /PartyIdentification/ID |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/CPTY |
FINCORP Account |
Not applicable |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference /PartyIdentification /ApplicationObjectKey/ID |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/XREF |
FINCORP Account |
Organizat- ion Id Acct Gen - Authorized Users - Last Name |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference /PartyIdentification/ ApplicationObjectKey/ContextID |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
Values are I or C (Individual customer or Corporate customer) |
FINCORP Account |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
FINCORP Account |
Acct Gen - Primary Contact Id |
/Status/Code |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/ACCSTAT |
FINCORP Account |
Account Status |
/ItemReference/ItemIdentification/ID |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/PRD |
FINCORP Account |
Name |
/MaturityDate |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/MATDT |
FINCORP Account |
Maturity Date |
/FinancialAccount Holder/Financial AccountSigning Authority/TypeCode |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/OTAPPDET/RESP |
FINCORP Account Contact |
Type |
/LoanAmount |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/OTAPPDET/AMOUNT |
FINCORP Account |
Loan Amount |
/DisbursedAmount |
FCUBSCL Service |
CL-Modify Acount-Notify-MSG.xsd |
FCUBS_NOTIFICATION/FCUBS_NOTIF_ IDENTIFIER/CLACCOUNTSUMMARY RESFULL/OTAPPDET/DISBAMT |
FINCORP BIB Account |
Amount Disbursed |
QueryLoanAccountEBM
QueryLoanAccountEBM is used to retrieve financial account information from Oracle FLEXCUBE Universal Banking.
Operation
Query
Service Consumer
Siebel CRM
Service Provider
Oracle FLEXCUBE Universal Banking
EBM Request and Response Operational Elements
QueryLoanAccountEBM/DataArea/QueryLoanAccount
QueryLoanAccountResponseEBM/DataArea/QueryLoanAccountResponse
Information about the LoanAccountEBM request-and-response messages is provided in the following topics.
QueryLoanAccountEBM
The following information lists the mapping information for the QueryLoanAccountEBM.
Table QueryLoanAccountEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/Identification/ID |
FCUBSCLService |
CL-Info-Qry-Req-Msg.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Info-Qry-Req/ACCNO |
FINCORP Account |
Account Number |
/Identification/ContextID |
FCUBSCLService |
CL-Info-Qry-Req-Msg.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Info-Qry-Req/BRN |
FINCORP BIB Account |
Branch Code |
/Identification/ ApplicationObjectKey /ContextID |
FCUBSCLService |
CL-Info-Qry-Req-Msg.xsd |
FCUBS_REQ_ENV/FCUBS_BODY/Info-Qry-Req/MODULE |
FINCORP Account |
Sub Type |
QueryLoanAccountResponseEBM
The following information lists the mapping information for the QueryLoanAccountResponseEBM.
Table QueryLoanAccountResponseEBM
| XML Path | Oracle FLEXCUBE Service Name | Oracle FLEXCUBE Interface Object | Oracle FLEXCUBE Interface Column | Siebel Contact Business Component | Siebel Contact Field |
|---|---|---|---|---|---|
/AccountNumber |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/ACCNO |
FINCORP Account |
Account Number |
/FinancialAccount Identification /ApplicationObjectKey /ContextID |
Not applicable |
Not applicable |
Hard coded to CL |
FINCORP Account |
Sub Type |
/FinancialAccount FinancialInstitution BranchBusinessUnit /FinancialAccount FinancialInstitution BranchBusinessUnit Reference/Business UnitIdentification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/BRN |
FINCORP BIB Account |
Branch Code |
/CurrencyCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CCY |
FINCORP Account |
Currency |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference/PartyIdentification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CPTY |
FINCORP BIB Account |
Not applicable |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference /PartyIdentification/ApplicationObjectKey/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/XREF |
FINCORP Account |
Organiza- tion Id Acct Gen - Authorized Users - Last Name |
/FinancialAccount Holder/Financial AccountPersonHolder /PersonPartyReference/ PartyIdentification/ ApplicationObjectKey/ContextID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
Values are I or C (Individual customer, Corporate customer) |
FINCORP BIB Account |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
FINCORP Account |
Acct Gen - Primary Contact Id |
/Status/Code |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/ACCSTAT |
FINCORP Account |
Account Status |
/ItemReference/ItemIdentification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/PRD |
FINCORP Account |
Name |
/MaturityDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/MATDT |
FINCORP Account |
Maturity Date |
/FinancialAccount Holder/Financial AccountSigning Authority/TypeCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/Othr-Applicants/RESP |
FINCORP Account Contact |
Type |
/BookedDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/BOOKDT |
FINCORP BIB Account |
Book Date |
/EffectiveDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/VALDT |
FINCORP Account |
Start Date |
/Status/SubStatusCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CONSTAT |
FINCORP BIB Account |
Contract Status |
/LoanAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/AMOUNT |
FINCORP Account |
Loan Amount |
/DisbursedAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/DISBAMT |
FINCORP BIB Account |
Amount Disbursed |
Components |
|||||
/LoanAccount Component/Identification/ID |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/COMPNAME |
FINCORP BIB Account Loan Components VBC |
Component Id |
/LoanAccount Component/TypeCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/COMPDESC |
FINCORP BIB Account Loan Components VBC |
Component Name |
/LoanAccount Component/Expected RepaidAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/EXPAMT |
FINCORP BIB Account Loan Components VBC |
Expected Amount |
/LoanAccount Component/Overdue Amount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/OVDAMT |
FINCORP BIB Account Loan Components VBC |
Overdue Amount |
/LoanAccount Component/Remaining Amount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/OUTSTDAMT |
FINCORP BIB Account Loan Components VBC |
Outstand- ing Amount |
/LoanAccount Component/Prepaid Amount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/ADVAMT |
FINCORP BIB Account Loan Components VBC |
Advance Amount |
/LoanAccount Component/Remaining Amount/@currencyCode |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/CCY |
FINCORP BIB Account Loan Components VBC |
Currency |
/LoanAccount Component/Effective InterestRate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/CLCOMPDET/INTRT |
FINCORP BIB Account Loan Components VBC |
Latest Interest Rate |
Schedules |
|||||
/LoanAccount ScheduledRepayment/Identification/ID |
Not applicable |
Not applicable |
Running serial number |
FINCORP BIB Account Loan Schedule VBC |
Component Id |
/LoanAccount ScheduledRepayment/RepaymentDate |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/DUEDATE |
FINCORP BIB Account Loan Schedule VBC |
Schedule Due Date |
/LoanAccount ScheduledRepayment/RepaymentAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/AMTSETT |
FINCORP BIB Account Loan Schedule VBC |
Amount Settled |
/LoanAccount ScheduledRepayment/OverdueAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/AMTDUE |
FINCORP BIB Account Loan Schedule VBC |
Amount Due |
/LoanAccount ScheduledRepayment /EquatedInstallment PrincipalAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/EMIAMT |
FINCORP BIB Account Loan Schedule VBC |
EMI Amount |
/LoanAccount ScheduledRepayment /CurrentCycleInterest AccrualAmount |
FCUBSCLService |
CL-Info-Qry-Res-FULL-Msg.xsd |
FCUBS_RES_ENV/FCUBS_BODY/Info-Qry-Res-FULL/COMPSCH/ACCRAMT |
FINCORP BIB Account Loan Schedule VBC |
Accrued Amount |
/LoanAccount ScheduledRepayment /EquatedInstallment TotalAmount |
Not applicable |
Not applicable |
The amortized principal is derived based on the EMI amount and the amount due For the interest component.This applies to amortized loans only. |
FINCORP BIB Account Loan Schedule VBC |
Amortized Principal |