My Oracle Support Banner

ECM: Unable to Delete External Bank Account Transfer ("Transfer To Account" Transaction) From the Semi Manual Reconciliation Page (Doc ID 2860684.1)

Last updated on APRIL 05, 2022

Applies to:

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

Symptoms

When trying to reverse an External Bank Account Transfer due to a problem with the transfer, the External Bank Account Transfer for the "Transfer To Account" still appears on the Semi Manual Reconciliation page. Expect it to no longer display since the External Bank Account Transfer for the "Transfer From Account" no longer displays on the Semi Manual Reconciliation page.

STEPS
1. On the External Accounts > Payment Methods page, setup two different Bank Accounts for the same Bank Code where Payment Method = Electronic Funds Transfer and Settle By = Financial Gateway  (Banking > Bank Accounts > External Accounts > Payment Methods)
   a. Bank = XXXXX
      Bank Account = YYYY
      Payment Method = Electronic Funds Transfer
      Settle By = Financial Gateway
      Layout = PAYMENTEIP
   b. Bank = XXXXX
      Bank Account = ZZZ
      Payment Method = Electronic Funds Transfer
      Settle By = Financial Gateway
      Layout = PAYMENTEIP

2. Add an External Bank Account Transfer, using the above Bank Accounts, with Payment Method = EFT  (Cash Management > Fees and Transfers > Bank Account Transfer)
   a. Transfer From Account
       Bank Code = XXXXX
       Bank Account = YYYY
   b. Transfer To Account
       Bank Code = XXXXX
       Bank Account = ZZZ

3. On the Select Settlements page, select the Payment and click Select Payments  (Cash Management > Settlements > Select Settlements)
4. Status changes to Approved
5. On the Payment Dispatch, select the Payment and dispatch it  (Financial Gateway > Process Payments > Payment Dispatch)
6. Once the Payment is dispatched, Process Run Status = Success
7. Run Automated Accounting  (Cash Management > Treasury > Accounting Automated Accounting)
8. On the Accounting Entries page, Accounting Entries created for the Payment  (Cash Management > Treasury > Accounting Accounting Entries)
9. On the Semi Manual Reconciliation page, enter the Bank ID and Account # for the "Transfer From Account" from Step 2a  (Banking > Reconcile Statements > Semi-Manual Reconciliation)
10. Bank Account Transfer appears for the "Transfer From Account" on the System Transactions side
11. On the Semi Manual Reconciliation page, enter the Bank ID and Account # for the "Transfer To Account" from Step 2b
12. Bank Account Transfer appears for the "Transfer To Account" on the System Transactions side
13. Since there is a problem with the Bank Account Transfer, need to run Reverse Accounting for the Accounting Entries from Step 8
     a. Run Reverse Accounting Request  (Cash Management > Treasury Accounting > Reverse Accounting Request)

14. On the Accounting Entries page, verify that the Reverse Accounting Entries were created
15. Since there is a problem with the Bank Account Transfer, need to place the Bank Transfer on Hold
     a. On the Override Payment Status page, select New Status = Awaiting Dispatch  (Financial Gateway > Administration > Override Payment Status)
     b. Click Save
     c. Current Status changes from Paid to Awaiting Dispatch
 
16. On the Payment Dispatch, place the Bank Account Transfer on Hold by checking the Select box and clicking Flag for Hold
     a. Dispatch Status changes to Flagged for Hold

17. On the Semi Manual Reconciliation page, enter the Bank ID and Account # for the "Transfer From Account" from Step 2a
18. Bank Account Transfer no longer appears for the "Transfer From Account" on the System Transactions side
19. On the Semi Manual Reconciliation page, enter the Bank ID and Account # for the "Transfer To Account" from Step 2b
20. Bank Account Transfer still appears for the "Transfer To Account" -- which is incorrect

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.