Siebel Innovation Pack 2015: 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

Service Consumer

Service Provider

EBM Request and Response Operational Elements

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

QueryDocumentaryCreditEBM

QueryDocumentaryCreditResponseEBM

Table 36 lists the mapping information for the QueryDocumentaryCreditResponseEBM.

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

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