ECM: Cash Forecast is Not Looking at the Worksheet Effective Date

(Doc ID 2346238.1)

Last updated on JANUARY 10, 2018

Applies to:

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

Symptoms

Effective date is not handled for worksheet line table leading to incorrect Cash forecast results. If there are multiple effective dated rows for the Worksheet definition then duplicate results are shown in the Cash Forecast results.

Steps:
---------
1) Worksheet Definition has two effective dated rows, say dated 2017 and 2000.
2) Check the Cash Forecasting result.

Expected result:
---------------------
Cash forecasting results for a value date 2016 should have used the 2000 year row from the setup.


Actual result:
---------------------
Results have duplicate rows for line items.

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