2.6 Request Payload Samples

This topic describes about the payload sample request for Oracle Banking Liquidity Management Integration.

Oracle FLEXCUBE Universal Banking

Oracle FLEXCUBE Universal Banking Balance Fetch
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:fcub="http://fcubs.ofss.com/service/FCUBSCoreentitiesService">
   <soapenv:Header/>
   <soapenv:Body>
   <FCUBS_REQ_ENV>
       <FCUBS_HEADER>
           <SOURCE>$fcubsheader.source</SOURCE>
           <UBSCOMP>FCUBS</UBSCOMP>
           <USERID>$fcubsheader.userid</USERID>
           <BRANCH>$fcubsheader.branch</BRANCH>
               <MODULEID>PX</MODULEID>
               <SERVICE>PMRftOutService</SERVICE>
               <OPERATION>CreateRftOut</OPERATION>
               <DESTINATION>FCUBS</DESTINATION>
         </FCUBS_HEADER>
       <FCUBS_BODY>
          <Master-IO>
            <REFNO>$fcubsbody.masterIO.refno</REFNO>
    #foreach($extSysAccountDetails in $fcubsbody.masterIO.input)
            <Input>
         <ACCNO>$.tag57AWIOPT</ACCNO>
               <TRNDT>$.tag57AWIBIC</TRNDT>
                <BALANCETYPE>$.tag59ACC</BALANCETYPE>
            </Input>
    #end
          </Master-IO>
                </FCUBS_BODY>
</FCUBS_REQ_ENV> 

Oracle FLEXCUBE Universal Banking Accounting Handoff

<FCUBS_REQ_ENV>
               <FCUBS_HEADER>
                   <SOURCE>$fcubsheader.source</SOURCE>
                   <UBSCOMP>FCUBS</UBSCOMP>
                   <MSGID>$fcubsheader.msgid</MSGID>
                     <CORRELID>$fcubsheader.correlid</CORRELID>
                   <USERID>$fcubsheader.userid</USERID>
                   <BRANCH>$fcubsheader.branch</BRANCH>
                     <MODULEID>PX</MODULEID>
                     <SERVICE>PMRftOutService</SERVICE>
                     <OPERATION>CreateRftOut</OPERATION>
                     <SOURCE_OPERATION>NEW</SOURCE_OPERATION>
                     <SOURCE_USERID>$fcubsheader.sourceuserid</SOURCE_USERID>
               <DESTINATION>$fcubsheader.destination</DESTINATION>
                     <MULTITRIPID>$fcubsheader.multitripid</MULTITRIPID>
                     <FUNCTIONID>$fcubsheader.functionid</FUNCTIONID>
                     <ACTION>NEW</ACTION>
                     <PASSWORD></PASSWORD>
               </FCUBS_HEADER>
               <FCUBS_BODY>
                   <Acc-Entry-Master-Full>

         <UNIQUEEXTREFNO>$fcubsbody.accEntryMasterFull.uniqueextrefno</UNIQUEEXTREFNO>
                     <TRNREFNO>$fcubsbody.accEntryMasterFull.trnrefno</TRNREFNO>
                       #foreach($AcctEntrydetailsdetails in      
               $fcubsbody.accEntryMasterFull.accEntryDetails)
                     <Acc-Entry-Details>
                     <DRCRIND>AcctEntrydetailsdetails.drcrind</DRCRIND>
                     <TRNREFNO>AcctEntrydetailsdetails.trnrefno</TRNREFNO>
                     <EVENT>AcctEntrydetailsdetails.event</EVENT>
                     <EXCHRATE>AcctEntrydetailsdetails.exchrate</EXCHRATE>
                     <EVENTSRNO>AcctEntrydetailsdetails.eventsrno</EVENTSRNO>
                     <VALUEDT>AcctEntrydetailsdetails.valuedt</VALUEDT>
                     <MODULE>AcctEntrydetailsdetails.module</MODULE>
                     <AMTTAG>AcctEntrydetailsdetails.amttag</AMTTAG>
                     <ACCCY>AcctEntrydetailsdetails.acccy</ACCCY>
                     <FCYAMT>AcctEntrydetailsdetails.fcyamt</FCYAMT>
                     <ACBRANCH>AcctEntrydetailsdetails.acbranch</ACBRANCH>
                     <ACNO>AcctEntrydetailsdetails.acno</ACNO>
                     <RELATEDACCOUNT>relatedaccount</RELATEDACCOUNT>
                     <LCYAMT>AcctEntrydetailsdetails.lcyamt</LCYAMT>
                     <TRNCODE>AcctEntrydetailsdetails.trncode</TRNCODE>
                 </Acc-Entry-Details>         
                   #end 
                   </Acc-Entry-Master-Full>
               </FCUBS_BODY>
         </FCUBS_REQ_ENV>

CreateEcablk(RTL)

<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
   <env:Header />
   <env:Body>
      <CREATEECABLK_FSFS_REQ
xmlns="http://fcubs.ofss.com/service/FCUBSCAService">
         <FCUBS_HEADER>
            <SOURCE>EXTSYS</SOURCE>
            <UBSCOMP>FCUBS</UBSCOMP>
            <USERID>$body.userId</USERID>
            <BRANCH>$body.branch</BRANCH>
            <SERVICE>FCUBSCAService</SERVICE>
            <OPERATION>CreateEcablk</OPERATION>
         </FCUBS_HEADER>
         <FCUBS_BODY>
            <Eca-Master-Full>
               <CREATEEXTREFNO>$body.createExtRefNo</CREATEEXTREFNO>
               <UPDASERRIFANYFAIL>N</UPDASERRIFANYFAIL>
               <BRN>$body.branch</BRN>
               <REFERRALALLOWED>N</REFERRALALLOWED>
               <Eca-Detail>
                  <CUSTACNO>$body.custAcNo</CUSTACNO>
                  <CUSTACBRN>$body.branch</CUSTACBRN>
                  <CUSTACCCY>$body.custAcCcy</CUSTACCCY>
                  <PARTIALBLKREQD>Y</PARTIALBLKREQD>
                  <REQBLKAMT>$body.reqBlkAmt</REQBLKAMT>
               </Eca-Detail>
            </Eca-Master-Full>
         </FCUBS_BODY>
      </CREATEECABLK_FSFS_REQ>
   </env:Body>
</env:Envelope>

CloseEcablk(RTL)

<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
   <env:Header />
   <env:Body>
      <CLOSEECABLK_FSFS_REQ xmlns="http://fcubs.ofss.com/service/FCUBSCAService">
         <FCUBS_HEADER>
            <SOURCE>EXTSYS</SOURCE>
            <UBSCOMP>FCUBS</UBSCOMP>
            <USERID>$body.userId</USERID>
            <BRANCH>$body.branch</BRANCH>
            <SERVICE>FCUBSCAService</SERVICE>
            <OPERATION>CloseEcablk</OPERATION>
         </FCUBS_HEADER>
         <FCUBS_BODY>
            <Eca-Master-Full>
               <UNDOEXTREFNO>$body.undoExtRefNo</UNDOEXTREFNO>
               <ECAREFNO>$body.ecaRefNo</ECAREFNO>
               <Eca-Detail>
                  <CUSTACNO>$body.custAcNo</CUSTACNO>
                  <CUSTACBRN>$body.custAcBrch</CUSTACBRN>
               </Eca-Detail>
            </Eca-Master-Full>
         </FCUBS_BODY>
      </CLOSEECABLK_FSFS_REQ>
   </env:Body>
</env:Envelope>

CreateRTLResponse(RTL)

<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
   <env:Header />
   <env:Body>
      <CREATERTLRESPONSE_FSFS_REQ xmlns="http://fcubs.ofss.com/service/FCUBSCAService">
         <FCUBS_HEADER>
            <SOURCE>EXTSYS</SOURCE>
            <UBSCOMP>FCUBS</UBSCOMP>
            <USERID>$body.userId</USERID>
            <BRANCH>$body.branch</BRANCH>
            <MODULEID>IF</MODULEID>
            <SERVICE>FCUBSCAService</SERVICE>
            <OPERATION>CreateRTLResponse</OPERATION>
            <SOURCE_OPERATION>CreateRTLResponse</SOURCE_OPERATION>
            <FUNCTIONID>IFDRTLRS</FUNCTIONID>
            <ACTION>NEW</ACTION>
            <MSGSTAT>$body.msgStat</MSGSTAT>
         </FCUBS_HEADER>
         <FCUBS_BODY>
            <Rtl-Queue-Full>
               <DDATXNREF>$body.ddaTxnRef</DDATXNREF>
               <RTLREFERENCENO>$body.rtlReferenceNo</RTLREFERENCENO>
               <TXNAMNT>$body.txnAmnt</TXNAMNT>
               <TXNCCY>$body.txnCcy</TXNCCY>
               <RTLSTATUS>$body.rtlStatus</RTLSTATUS>
               <RTLSTATUSMESSAGE>$body.rtlStatusMessage</RTLSTATUSMESSAGE>
            </Rtl-Queue-Full>
         </FCUBS_BODY>
      </CREATERTLRESPONSE_FSFS_REQ>
   </env:Body>
</env:Envelope>

Oracle Banking Virtual Account Management

Balance fetch

{
  "sweepandVDBalanceServiceRequestDto": [
    {
      "virtalAccountNumber": "string",
      "valueDate": "string"
    }
  ]
}

Handoff

{
  "sourceCode": "string",
  "sourceReferenceNo": "string",
  "vatRequestDetServiceDTO": [
    {
      "drCrInd": "string",
      "txnAccount": "string",
      "txnAccountBrn": "string",
      "txnCcy": "string",
      "txnAccountCcy": "string",
      "amtInTxnAccCcy": 0,
      "txnAmount": 0,
      "txnCode": "string",
      "valueDate": "string",
      "exchRate": 0,
      "reconRefNo": "string",
      "addlText": "string",
      "ecaOrBlockRefNo": "string",
      "ddaOffset": "string",
      "forceDebit": "N",
      "blkReleaseStatus": "string"
    }
  ]
}

Oracle Banking Payments

PMRftOutService - MT101

<FCUBS_REQ_ENV>
	    <FCUBS_HEADER>
	        <SOURCE>$fcubsheader.source</SOURCE>
	        <UBSCOMP>FCUBS</UBSCOMP>
	        <MSGID>$fcubsheader.msgid</MSGID>
		    <CORRELID></CORRELID>
	        <USERID>$fcubsheader.userid</USERID>
	        <BRANCH>$fcubsheader.branch</BRANCH>
			<MODULEID>PX</MODULEID>
			<SERVICE>PMRftOutService</SERVICE>
			<OPERATION>CreateRftOut</OPERATION>
			<SOURCE_OPERATION>NEW</SOURCE_OPERATION>
      		<SOURCE_USERID></SOURCE_USERID>
     		<DESTINATION></DESTINATION>
      		<MULTITRIPID></MULTITRIPID>
      		<FUNCTIONID></FUNCTIONID>
      		<ACTION></ACTION>
      		<PASSWORD></PASSWORD>
		</FCUBS_HEADER>
	    <FCUBS_BODY>
	       <Msg-Out101-Full>
	         <REFERENCE_NO>$fcubsbody.msgOut101IO.referenceno</REFERENCE_NO>
         <HOST_CODE>$fcubsbody.msgOut101IO.hostcode</HOST_CODE>
         <BRANCH_CODE>$fcubsbody.msgOut101IO.branchcode</BRANCH_CODE>
         <CUSTOMER_NO>$fcubsbody.msgOut101IO.customerno</CUSTOMER_NO>
         <RECEIVER>$fcubsbody.msgOut101IO.receiver</RECEIVER>
         <TAG28D_MSGINX>$fcubsbody.msgOut101IO.tag28DMSGINX</TAG28D_MSGINX>
         <TAG28D_MSGTOT>$fcubsbody.msgOut101IO.tag28DMSGTOT</TAG28D_MSGTOT>
         <TAG50_ORD_OPT>$fcubsbody.msgOut101IO.tag50ORDOPT</TAG50_ORD_OPT>
         <TAG50_ORD_ACC>$fcubsbody.msgOut101IO.tag50ORDACC</TAG50_ORD_ACC>
         <TAG50_ORD_ADD1>$fcubsbody.msgOut101IO.tag50ORDADD1/add1</TAG50_ORD_ADD1>
         <TAG50_ORD_ADD2>$fcubsbody.msgOut101IO.tag50ORDADD2</TAG50_ORD_ADD2>
         <TAG50_ORD_ADD3>$fcubsbody.msgOut101IO.tag50ORDADD3</TAG50_ORD_ADD3>
         <TAG30>$fcubsbody.msgOut101IO.tag30</TAG30>
         <TAG25>$fcubsbody.msgOut101IO.tag25</TAG25>
         <SOURCE_CODE>$.</SOURCE_CODE>
	 #foreach($msgoutdetails in $fcubsbody.msgOut101IO.msgOut101Detail)
	<Msg-Out101-Detail>
	   <TAG57_AWI_OPT>$msgoutdetails.tag57AWIOPT</TAG57_AWI_OPT>
            <TAG57_AWI_BIC>$msgoutdetails.tag57AWIBIC</TAG57_AWI_BIC>
            <TAG59_ACC>$msgoutdetails.tag59ACC</TAG59_ACC>
            <TAG59_ADD1>$msgoutdetails.tag59ADD1/add1</TAG59_ADD1>
            <TAG71A>$msgoutdetails.tag71A</TAG71A>
            <TAG23E_LINE1>$msgoutdetails.tag23ELINE1</TAG23E_LINE1>
            <TAG32B_CCY>$msgoutdetails.tag32BCCY</TAG32B_CCY>
            <TAG32B_AMOUNT>$msgoutdetails.tag32BAMOUNT</TAG32B_AMOUNT>
        </Msg-Out101-Detail>
	#end
	</Msg-Out101-Full>
	    </FCUBS_BODY>
	</FCUBS_REQ_ENV>

PMSinglePayOutService - MT103

<FCUBS_REQ_ENV>
	    <FCUBS_HEADER>
	        <pms.SOURCE>$fcubsheader.source</pms.SOURCE>
	        <pms.UBSCOMP>FCUBS</pms.UBSCOMP>
	        <pms.MSGID>$fcubsheader.msgid</pms.MSGID>
		    <pms.CORRELID></pms.CORRELID>
	        <pms.USERID>$fcubsheader.userid</pms.USERID>
	        <pms.BRANCH>$fcubsheader.branch</pms.BRANCH>
			<pms.MODULEID>PX</pms.MODULEID>
			<pms.SERVICE>PMRftOutService</pms.SERVICE>
			<pms.OPERATION>CreateRftOut</pms.OPERATION>
			<pms.SOURCE_OPERATION>NEW</pms.SOURCE_OPERATION>
      		<pms.SOURCE_USERID>$fcubsheader.sourceuserid</pms.SOURCE_USERID>
     		<pms.DESTINATION>$fcubsheader.destination</pms.DESTINATION>
      		<pms.MULTITRIPID>$fcubsheader.multitripid</pms.MULTITRIPID>
      		<pms.FUNCTIONID>$fcubsheader.functionid</pms.FUNCTIONID>
      		<pms.ACTION>$fcubsheader.action</pms.ACTION>
      		<pms.PASSWORD>$fcubsheader.password</pms.PASSWORD>
		</FCUBS_HEADER>	    
<FCUBS_BODY>
	<pms:CstmrCdtTrfInitn>
         <pms:GrpHdr>
            <pms:MsgId>$fcubsbody.cstmrCdtTrfInitn.grpHdr.msgId</pms:MsgId>
<pms:CreDtTm>$fcubsbody.cstmrCdtTrfInitn.grpHdr.creDtTm</pms:CreDtTm>

<pms:Authstn>$fcubsbody.cstmrCdtTrfInitn.grpHdr.authstn</pms:Authstn>

<pms:NbOfTxs>$fcubsbody.cstmrCdtTrfInitn.grpHdr.nbOfTxs</pms:NbOfTxs>

<pms:InitgPty>$fcubsbody.cstmrCdtTrfInitn.grpHdr.initgPty</pms:InitgPty>
	 </pms:GrpHdr>
         <pms:PmtInf>
<pms:PmtInfId>$fcubsbody.cstmrCdtTrfInitn.pmtInf.pmtInfId</pms:PmtInfId>
            <pms:PmtMtd>$fcubsbody.cstmrCdtTrfInitn.pmtInf.pmtMtd</pms:PmtMtd>
            <pms:PmtTpInf>
<pms:InstrPrty>$fcubsbody.cstmrCdtTrfInitn.pmtInf.pmtTpInf.instrPrty</pms:InstrPrty>
               <pms:SvcLvl>
<pms:Cd>$fcubsbody.cstmrCdtTrfInitn.pmtInf.pmtTpInf.svcLvl.cd</pms:Cd>
               </pms:SvcLvl>
               <pms:CtgyPurp>
<pms:Cd>$fcubsbody.cstmrCdtTrfInitn.pmtInf.pmtTpInf.ctgyPurp.cd</pms:Cd>
               </pms:CtgyPurp>
            </pms:PmtTpInf>
<pms:ReqdExctnDt>$fcubsbody.cstmrCdtTrfInitn.pmtInf.reqdExctnDt</pms:ReqdExctnDt>
            <pms:Dbtr>
               <pms:Nm>$fcubsbody.cstmrCdtTrfInitn.pmtInf.dbtr.nm</pms:Nm>
               <pms:PstlAdr/>
               <pms:Id>
                  <pms:OrgId>
                     <pms:ClrSysMmbId/>
                     <pms:Othr>
<pms:Id>$fcubsbody.cstmrCdtTrfInitn.pmtInf..dbtr.id.orgId.othr.id</pms:Id>
                        <pms:SchmeNm>
<pms:Cd>$fcubsbody.cstmrCdtTrfInitn.pmtInf.dbtr.id.orgId.othr.schmeNm.cd</pms:Cd>
                        </pms:SchmeNm>
                     </pms:Othr>
                  </pms:OrgId>
               </pms:Id>
            </pms:Dbtr>
            <pms:DbtrAcct>
               <pms:Id>
                  <pms:Othr>
<pms:Id>$fcubsbody.cstmrCdtTrfInitn.pmtInf.dbtrAcct.id.othr.id</pms:Id>
                  </pms:Othr>
               </pms:Id>
<pms:Ccy>$fcubsbody.cstmrCdtTrfInitn.pmtInf.dbtrAcct.ccy</pms:Ccy>
            </pms:DbtrAcct>
            <pms:DbtrAgt/>
            <pms:DbtrAgtAcct>
               <pms:Id>
                  <pms:Othr/>
               </pms:Id>
            </pms:DbtrAgtAcct>
            <pms:CdtTrfTxInf>
               <pms:PmtId>
<pms:InstrId>$fcubsbody.cstmrCdtTrfInitn.pmtInf.cdtTrfTxInf.pmtId.instrId</pms:InstrId>
<pms:EndToEndId>$fcubsbody.cstmrCdtTrfInitn.pmtInf.cdtTrfTxInf.pmtId.endToEndId</pms:EndToEndId>
               </pms:PmtId>
               <pms:Amt>
                  <pms:InstdAmt
Ccy="USD">$fcubsbody.cstmrCdtTrfInitn.pmtInf.cdtTrfTxInf.amt.instdAmt</pms:InstdAmt>
                  <pms:EqvtAmt/>
               </pms:Amt>
               <pms:CdtrAgt/>
               <pms:CdtrAgtAcct>
                  <pms:Id>
                     <pms:Othr/>
                  </pms:Id>
               </pms:CdtrAgtAcct>
               <pms:Cdtr>
<pms:Nm>$fcubsbody.cstmrCdtTrfInitn.pmtInf.cdtTrfTxInf.cdtr.nm</pms:Nm>
                  <pms:PstlAdr/>
               </pms:Cdtr>
               <pms:CdtrAcct>
                  <pms:Id>
                     <pms:Othr>
<pms:Id>$fcubsbody.cstmrCdtTrfInitn.pmtInf.cdtTrfTxInf.cdtrAcct.id.othr.id</pms:Id>
                     </pms:Othr>
                  </pms:Id>
               </pms:CdtrAcct>
            </pms:CdtTrfTxInf>
            <pms:Misdetails/>
         </pms:PmtInf>
         <pms:GrpTlr>
<pms:TxnBranch>$fcubsbody.cstmrCdtTrfInitn.grpTlr.txnBranch</pms:TxnBranch>
<pms:HostCode>$fcubsbody.cstmrCdtTrfInitn.grpTlr.hostCode</pms:HostCode>
<pms:SourceCode>$fcubsbody.cstmrCdtTrfInitn.grpTlr.sourceCode</pms:SourceCode>
<pms:NetworkCode>$fcubsbody.cstmrCdtTrfInitn.grpTlr.networkCode</pms:NetworkCode>
         </pms:GrpTlr>
      </pms:CstmrCdtTrfInitn>
	  </FCUBS_BODY>
      </FCUBS_REQ_ENV>

Oracle Banking Digital Experience

Execute Sweep Structure
{
  		"overRidePending": "N",
 		 "allowMbccAccountPair": "N",
  		 "mode": "A",
  		"structureList": [
    			{
      			"structureId": "ST20217167444516010503",
      			"versionNumber": 1
    			}
 		                  ]
	   }