ECM: Bank Transfer with Intermediary Bank Details is Storing PS_PMT_INTRM_TBL.STL_ROUTING_METHOD and INTRM_DFI_ID_QUAL Incorrectly (Doc ID 1447475.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Bank Transfer with Intermediary Bank details is storing PS_PMT_INTRM_TBL.STL_ROUTING_METHOD and INTRM_DFI_ID_QUAL incorrectly.

STEPS


1. Bank external account (Beneficiary Bank)
    TRBNK/CHCK
    Account Settlement:
    Instructions: TUS01
    Currency Code: USD
    Rootings:
      Rooting id: DFI ID
      DFI Qualifier: Mutually Defined
      DFI ID: INGBROBU
      Payment Message: 02-ING_ROM

(Navigation: Banking > Bank Accounts > External Accounts)


2. Bank external account (From Account)
   USBNK/CHCK
   Payment method: ACH
   Financial Gayeway - Layout: 820 ACH


3. Create Bank Account Transfer
    From: USBNK/CHCK
    To: TRBNK/CHCK

(Navigation: Cash Management > Fees and Transfers > Bank Account Transfer)


4. Select Settlements.

(Navigation: Cash Management > Settlements > Select Settlements)


5. Approve Settlements.

(Navigation: Cash Management > Settlements > Approve Settlements)


6. Check on PS_PMT_INTRM_TBL STL_ROUTING_METHOD: Value is 02 which stands for Bank and not DFI ID (01) specified on routing page.
    Check on PS_PMT_INTRM_TBL.INTRM_DFI_ID_QUAL: Value is bank. The DFI Qualifier (INTRM_DFI_ID_QUAL) should be 'Mutually Defined' specified on DFI Qualifier field on Routings page.

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