CM-Financial Gateway - Acknowledgement File - Error Message Not Getting Updated
(Doc ID 2184935.1)
Last updated on JULY 07, 2020
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
We send the payments to the bank, in two instances there were error in the file and the acknowledgment (997) file list out the error in detail as follows,
From Bank ACK file:
AK4*1**1*Receiving Party Bank ID; Data not recognized as acceptable; BOFAUS3N\
AK4*2**1*Receiving Party Bank ID; Data does not meet required length; BOFAUS3N\
We are on FSCM 9.1 Bundle #23 , Tools 8.52.09
But unfortunately the Peoplesoft FG pages still shows "Recieved by bank" and not updated to error status with error information. This happened couple of times. The acknowledgement program ran to success with no issue.
Set Up / Configurations
Set Payment Acknowledgements for layout 820
Banking > Administer Bank Integration > Bank Integration Layouts
Bank Account USBNK
Payment Method ‘Wire Transfer’ Layout ‘820’ Settled By Financial Gateway
Banking > Bank Accounts > External Bank Accounts
Payment Methods tab
Create a EFT Request
Cash Management > Fees and Transfers > EFT Request
Cash Management > Settlements > Select Settlements
Cash Management > Settlements > Approve Settlements
Financial Gateway > Process Payment > Payment Dispatch
Payment dispatch results
Import 997 Acknowledgement File, with Status = “Reject”.
Edit the file to denote the correct file id
In my example, the file id is ‘00000007’
ISA*00* *00* *ZZ*1388111112 *ZZ*021001033T *100216*1747*U*00401*000000006*0*T*~
Import Payment Acknowledgement File
Financial Gateway > Process Payments > Import Acknowledgement Files
• Results of the import
Navigation: Financial Gateway > Review Payments > Acknowledgement Files
File in Error
Associate payment does not have status updated (i.e., Dispatch Status is still “Dispatched to Bank”).
Financial Gateway > Review Payments > Payment Files
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document