EAP: FIN2025 Failes in DB2 Environment With Error "***warning***: Write-EFT-File. unknown layout:"
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