R12/CE: Cash Position Prior Day Cash Flow and Overdue Transactions Program completes in error FDPSTP failed due to ORA-01841

(Doc ID 1910215.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.5Cloud [Release 12 to 12.2Cloud]
Information in this document applies to any platform.

Symptoms

On : 12.2 and above version, Cash Positioning

The issue can be reproduced at will with the following steps:
1.Cash Positions
2. Default Cash Position Worksheet
3.Generate Cash Positions

As of date -XXXX
Factor- Unit
Currency Blank
View by Currency
Apply

Get Message 'No prior day cash flow balance was found for worksheet Default Cash Position Worksheet as of 23-Jul-2014. Do you want to run the Cash Position Prior Day Cash Flow and Overdue Transactions Program to generate the prior day cash flow and overdue transactions balances now?'

Select yes and Submit the 'Cash Position Prior Day Cash Flow and Overdue transactions Program'
Request completes in Error Status

Log file shows error
ORACLE error 1841 in FDPSTP

Cause: FDPSTP failed due to ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "APPS.CE_CP_PRIORDAY", line 35
ORA-06512: at "APPS.CE_CP_PRIORDAY", line 768
ORA-06512: at line 1

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