My Oracle Support Banner

ECM: PMT_ID Not Updated On CASH_FLOW_TR Record When Doing AWE Approvals For Bank Transfers (Doc ID 2746135.1)

Last updated on JANUARY 22, 2021

Applies to:

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

Symptoms

BAX- missing PMT_ID on CASH_FLOW_TR record when doing AWE approvals

Since the PMT_ID is missing, its causing issues reconciling the bank statements

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Non working scenario:

1. Log in as VP1
2. Enable AWE workflow in Treasury Business unit options for US001 and uncheck self approval
3. On the AWE setup, uncheck self approval
4. Create a bank transfer for USBNK/CHCK to TRBNK/CHCK
5. 4 rows are created on the CASH_FLOW_TR and with PYMNT_SELCT_STATUS = X, CASH_FLOW_LEG = 1 for all 4 rows
6. Select the payment under settlement manager
7. On select, on the CASH_FLOW_TR table, only cash_flow_line = 2 is updated with PYMNT_SELCT_STATUS = N and APPROVAl_FLG_TR = P along with select details. PMT_ID is blank for all 4 rows.
8. Log in as VP2 and approve the above settlement
9. On approval, on the CASH_FLOW_TR table, only cash_flow_line = 2 is updated with APPROVAl_FLG_TR = A along with approval details. PMT_ID is updated only for this row and blank for other rows.


working scenario:

1. Log in as VP1
2. Enable manual workflow in Treasury Business unit options for US001 and uncheck self approval
3. Create a bank transfer for USBNK/CHCK to TRBNK/CHCK
4. 4 rows are created on the CASH_FLOW_TR and with PYMNT_SELCT_STATUS = X, CASH_FLOW_LEG = 1 for all 4 rows
5. Select the payment under settlement manager
6. On select, on the CASH_FLOW_TR table, only cash_flow_line = 2 is updated with PYMNT_SELCT_STATUS = N and APPROVAl_FLG_TR = P along with select details. PMT_ID is blank for all 4 rows.
7. Approve the above settlement under settlement manager
8. On approval, on the CASH_FLOW_TR table, cash_flow_line = 2 is updated with APPROVAl_FLG_TR = A along with approval details. PMT_ID is updated for 2 rows(from and to bank account rows) and blank for other rows
 

Changes

 

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
Changes
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.