R12/CE: Cash Position Prior Day Cash Flow and Overdue Transactions Program completes in error FDPSTP failed due to ORA-01841
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.
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
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