Bookshelf Home | Contents | Index | PDF     

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

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

Table 37 lists the mapping information for the QueryBankGuaranteeEBM.

Table 37. 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

Table 38 lists the mapping information for the QueryBankGuaranteeResponseEBM.

Table 38. 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
      
Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.