ECM: CCD+ Payment File Generated via Financial Gateway For A Bank Transfer Transaction Does Not Have The Expected Settlement Date, as PS_PMT_DETAIL_TBL.ESTIMATED_DUE_DATE is NULL (Doc ID 2115499.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

CCD+ payment file generated via Financial Gateway for a bank transfer does not have the expected settlement date

STEPS:

Ensure EFT Payment Format code is setup to have Settlement Days as 2 (Setup Financials > Common Definitions > EFT)
Ensure the Settlement Instructions for the To Bank Account have the above EFT Payment format selected on the EFT Options link (Banking > Bank Accounts > Settlement Instructions)
1) Create a external bank transfer
2) Select and approve settlement to be processed via financial gateway
3) Run payment dispatch

Payment file generated has PS_PMT_DETAIL_TBL.PYMNT_DT as the ACH_EFF_ENTRY_DATE in record 5 of CCD+ file

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