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

Service Consumer

Service Provider

EBM Request and Response Operational Elements

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

QueryFinancialTransactionListEBM

Table 52 lists the mapping information for the QueryFinancialTransactionListEBM.

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

Table 53 lists the mapping information for the QueryFinancialTransactionListResponseEBM.

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

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