EAP: FIN2025 Failes in DB2 Environment With Error "***warning***: Write-EFT-File. unknown layout:"

(Doc ID 2135500.1)

Last updated on JULY 11, 2016

Applies to:

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


FIN2025 fails in DB2 environment with multiple errors.


The issue can be reproduced at will with the following steps:
1. Setup the ACH/EFT Payment method in the banking setup for settle through paycycle.
2. Create a voucher with the same bank and payment method (ACH).
3. Pay the voucher using paycycle.
4. Run FIN2025 (Electronic Payment process).


Process failed with errors in output file:

Error:- 1 CCD+ layout is not recognized

          $eft_layout_srch :CCD+ :
          ***warning***: Write-EFT-File. unknown layout:CCD+ :

Error:- 2 Process abending due to SQL error

          FIN2025.SQR,Update-Advice-Rpt,Insert,PS_EFT_ADVICE_TMP SQL Status = -302, SQL Error = SQL0302N The value of a host variable in the
          EXECUTE or OPEN statement is out of range for its corresponding use.

          Error on line 71:
          (SQR 3301) Program stopped by user request.

          SQR for PeopleSoft: Program Aborting.


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