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

(Doc ID 1562657.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for Currency on 19-Nov-2014 ***


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 720-40000022.

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.


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