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

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

Table 33 lists the mapping information for the QueryDocumentaryCollectionEBM.

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

Table 34 lists the mapping information for the QueryDocumentaryCollectionResponseEBM.

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

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