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 JUNE 12, 2020
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.
On : 12.2 and above version, Cash Positioning
The issue can be reproduced at will with the following steps:
2. Default Cash Position Worksheet
3.Generate Cash Positions
As of date -XXXX
View by Currency
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
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