CM-Financial Gateway - Acknowledgement File - Error Message Not Getting Updated (Doc ID 2184935.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

ISSUE:
=====
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.


STEPS
=====

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
  
Select Settlements
Cash Management > Settlements > Select Settlements

Approve Settlements
Cash Management > Settlements > Approve Settlements

Dispatch Settlements
Financial Gateway > Process Payment > Payment Dispatch
Click OK
Enter Password
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*~
GS*RA*1388111112*021001033T*20100216*1747*000000007*X*004010~
ST*997*0001~
AK1*RA*000000007~
AK2*820*CM0000000084~
AK5*A~
AK9*A*1*1*1~
SE*6*0001~
GE*1*000000007~
IEA*1*000000006~

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

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