Investor Agreement Activation Error "ORA-01400: cannot insert NULL into ("OKL"."OKL_STRM_ELEMENTS"."AMOUNT") in Package Okl_Sel_Pvt Procedure V_tbl_insert_row"
(Doc ID 3000080.1)
Last updated on MARCH 01, 2024
Applies to:
Oracle Lease and Finance Management - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
The investor agreement activation is erroring out for contracts with Finance Fee line payments in arrears having zero payment line at the end after non zero payment line with the following error:
ERROR
-----------------------
OKL_SEC_CONCURRENT_PVT.ACTIVATE_AGREEMENT:::: Processing Started.
OKL_SEC_CONCURRENT_PVT.ACTIVATE_AGREEMENT::Okl_Sec_Concurrent_Pvt.Activate_Agreement:: Unexpected error.
ORA-01400: cannot insert NULL into ("OKL"."OKL_STRM_ELEMENTS"."AMOUNT") in Package Okl_Sel_Pvt Procedure V_tbl_insert_row
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using lease super user responsibility, author a contract and book it.
2. Contract should have the following configuration:
- Asset payments in arrears.
- Finance Fee line in arrears.
- Payments should have a zero at the end after the non-zero payment line in Fin Fee payments.
3. Create the Fixed Pool.
4. Create an investor agreement for fixed inv product and change the disb amount percent.
5. Activate the IA and receive the error.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |