R12: AP/IBY: Payee Bank Accounts Are Intermittently Missing From Payments Using the Extract Identity Template (Doc ID 2064333.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Payments - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Payee bank account numbers are not always included in the outbound payment files based on the seeded Extract Identity payment template.
Examining the payment extract confirms the banking details are present before applying the Extract Identity template.

Original payment extract shows:

<OutboundPaymentInstruction>
    ...
    <OutboundPayment>
    ...
        <PayeeBankAccount>
        ...
            <BankAccountNumber>123456789</BankAccountNumber>

  

Formatted XML output file shows:

<OutboundPaymentInstruction>
    ...
    <OutboundPayment>
    ...
        <PayeeBankAccount>
        ...
            <BankAccountNumber/>

  

The issue does not consistently affect a given payee or bank account.
Resubmitting a payment batch for the same payments may cause different accounts to be affected, or none at all.

EXPECTED BEHAVIOR
Payee bank account numbers should consistently be included in payment files.
The seeded Extract Identity template should provide all data originally present in the payment extract in the resulting formatted XML file.

STEPS
The issue can be reproduced at will with the following steps:
1. Submit payment
2. Process payment through Formatted stage
3. Observe payment file output sometimes does not include the payee bank account number for some outbound payments

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, large payment batches are being rejected by the bank due to missing information.

Changes

Oracle Payments Recommended Patch Collection (RPC) 2 was recently installed.

Functionality included in this patch allowed bank account encryption attribute tags to be introduced into payment extracts.

 

Before installation:

<OutboundPaymentInstruction>
    ...
    <OutboundPayment>
    ...
        <PayeeBankAccount>
        ...
            <BankAccountNumber>123456789</BankAccountNumber>
            <MaskedBankAccountNumber>XXXXX6789</MaskedBankAccountNumber>
            <UserEnteredBankAccountNumber>123456789</UserEnteredBankAccountNumber>

After installation:

<OutboundPaymentInstruction>
    ...
    <OutboundPayment>
    ...
        <PayeeBankAccount>
        ...
            <BankAccountNumber E="N" MS="DISPLAY_LAST" UL="4">123456789</BankAccountNumber>
            <MaskedBankAccountNumber>XXXXX6789</MaskedBankAccountNumber>
            <UserEnteredBankAccountNumber E="N" MS="DISPLAY_LAST" UL="4">123456789</UserEnteredBankAccountNumber>

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms