My Oracle Support Banner

ECM: Cash Forecast Results show Incorrect Values (Doc ID 2872399.1)

Last updated on MAY 25, 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

After running cash forecast (TR_CSH_FCST) cash forecast for consecutive days after voucher closure results incorrect values related to the PS_CSH_FCST_SUM_VW.


STEPS
-----------------------
1. Cash Management–Cash Forecast–Define Cash Forecast–Define Time Sets. Define a time set    
2. Cash Management–Cash Forecast–Define Cash Forecast–Position Source Set. Define a position source set    
3. Create a view (in application designer) for testing the future voucher closure    
4. Cash Management–Cash Forecast–Define Cash Forecast–Position Source. Define a position source for the above view in step 3
5. Cash Management-Cash Forecast-Define Cash Forecast-Create Position Source SQL. Create position source SQL    
6. Cash Management-Cash Forecast-Define Cash Forecast-Calculate Time Span. Calculate time span    
7. Cash Management-Cash Forecast-Define Cash Forecast-Worksheet Definition. Create a worksheet for the above position source set.
8. Create multiple vouchers that match the view criteria from step 3.    
9. Cash Management–Cash Forecast–Process and Review–Schedule Cash Forecast. Run the cash forecast process.
10.Cash Management–Cash Forecast–Process and Review–Cash Forecast Results. Create a new search and verify the results. The voucher amounts are correctly shown.
11.Accounts Payable–Vouchers–Add/Update–Close Vouchers. Close the above vouchers.    
12.Accounts Payable–Batch Processes–Vouchers–Voucher Posting. Run voucher post for the voucher closure.    
13.Cash Management – Cash Forecast – Process and Review – Schedule Cash Forecast. Run the forecast process again on the next day.
14.Cash Management–Cash Forecast–Process and Review–Cash Forecast Results. Verify the cash forecast results and observe that the amounts are blanked out.   

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.