My Oracle Support Banner

Program Error: SQLerrm=ORA-01841 (full) Year Must Be Between -4713 And +9999, and not be 0 (Doc ID 1562657.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version,

When attempting to perform a Manual Termination - Without Purchase with the reason of "Repossession", the termination quote gets stuck in Accepted status and termination transaction show the following error during the Amortization stage:

Step: Amortization
Program Error: An unexpected error was encountered. Error code - &ERROR_CODE Error message - &ERROR_MESSAGE Action: Contact your system administrator. (SQLcode=-1841) (SQLerrm=ORA-01841: (full) year must be between -4713 and +9999, and not be 0).
Error occurred during the amortization process for assets of contract <CONTRACT_NUMBER>.

The issue can be reproduced at will with the following steps:
1. Create a contract with any financial product
2. Book the contract
3. Bill and Accrue
4. Create a termination quote of type Manual Termination - Without Purchase, with Reason of "Repossession"
5. Submit the quote for approval
6. Accept the quote
7. Look at the termination transaction and they show the above error.




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.