ECM: Approved Bank Transfer does not move to Financial Gateway (Doc ID 1680571.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

Approve Bank Transfer that uses a Transfer Template does not to move to Financial Gateway when it should be.

STEPS
1. Create Enter Transfer Template and Approve it
FROM: Bank = DEMO1 / Account = CHK1 / BU GL = US003
TO: Bank = USBNK / Account = CHCK / BU GL = US001

2. Create Bank Account Transfer for $10 using the Bank Transfer Template from Step 1
PS_CASH_FLOW_TR
ACCT_BUS_UNIT_GL / STL_THROUGH BASE_AMT / APPROVAL_FLG_TR / PYMNT_SELCT_STATUS
US001 / null value / 0.00 / N / X
US003 / null value / 0.00 / N / X

3. Select Settlements
PS_CASH_FLOW_TR
ACCT_BUS_UNIT_GL / STL_THROUGH / BASE_AMT / APPROVAL_FLG_TR / PYMNT_SELCT_STATUS
US001 /null value / 0.00 / N / X
US003 / 01       / -10.00 / P / N

4. Unselect Settlements
PS_CASH_FLOW_TR
ACCT_BUS_UNIT_GL / STL_THROUGH / BASE_AMT / APPROVAL_FLG_TR / PYMNT_SELCT_STATUS
US001 / null value / 0.00 / N / X
US003 /01         / -10.00 / N  /X

5. Display the Bank Transfer page and update the amount from $10 to $11
PS_CASH_FLOW_TR
ACCT_BUS_UNIT_GL / STL_THROUGH / BASE_AMT / APPROVAL_FLG_TR / PYMNT_SELCT_STATUS
US001 / null value / 0.00 / N / X
          / null value / 0.00 / N / X

6. Re-select the updated Bank Transfer using Select Settlements
PS_CASH_FLOW_TR
ACCT_BUS_UNIT_GL / STL_THROUGH / BASE_AMT / APPROVAL_FLG_TR / PYMNT_SELCT_STATUS
US001       / null value / 0.00 / N / X
null value / 01        / -11.00 / P / N

ACCT_BUS_UNIT_GL and STL_THROUGH are both now blank and will cause this to not be sent to the Financial Gateway.

7. Approve Settlements
PS_CASH_FLOW_TR
ACCT_BUS_UNIT_GL / STL_THROUGH / BASE_AMT / APPROVAL_FLG_TR / PYMNT_SELCT_STATUS
US001       / null value / 0.00 / N / X
null value /null value / -11.00 / A / N

8. Run Payment Dispatch

9. Bank Transfer does not move on to the Financial Gateway

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