My Oracle Support Banner

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:
1.Cash Positions
2. Default Cash Position Worksheet
3.Generate Cash Positions

As of date -XXXX
Factor- Unit
Currency Blank
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.