Bank Information Missing From Settlement Batches Output File For One Customer (Doc ID 1499402.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Find that bank information is missing from the settlement file for one particular customer.  Bank information is present in the output file for other customers.  
 
Template is IBYCE_en.rtf 120.2.12000000.3.
FundscaptureOrder record.
Starting at position 87 for 16 spaces, we see:
PayerBankAccount/BankAccountNumber
(Comments=Customer Bank Account Number)
In the 'Create Settlement Batches' output file, this is blank for one particular customer.

Details:

In iby_trxn_summaries_all for the settlement batch, PAYERINSTRID is populated for all records.

For this customer, there is no <PayerBankAccount> information in the XML extract, whereas it is present for other customers.

The view IBY_XML_FNDCPT_BANKACCOUNT_V is used for populating the bank account details in the extract.  File version is ibyxmlv.odf 120.33.12010000.19.

The following query for this customer returns no records:
select xmltype.getclobval(BANK_ACCOUNT_CONTENT) from
IBY_XML_FNDCPT_BANKACCOUNT_V where instrid=<instrid>;

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.