Lease With Daily Payments Error With ORA-01400: Cannot Insert NULL Into FLA_LEASE_PAYMENT_LINES.PAYMENT_LINE_END_DATE
(Doc ID 2883676.1)
Last updated on FEBRUARY 08, 2024
Applies to:
Oracle Fusion Lease Accounting - Version 11.13.22.01.0 to 11.13.22.07.0 [Release 1.0]Information in this document applies to any platform.
Symptoms
When attempting to import leases with daily payments, system error with the following error:
An application error occurred while processing a lease contract: ORA-01400: cannot insert NULL into ("FUSION"."fla_lease_payment_lines"."PAYMENT_LINE_END_DATE"). Package FLA_LEASE_PAYMENT_LINES_PKG.create_payment_lines_bulk at main.
The issue can be reproduced at will with the following steps:
1. Populate lease data into LeaseContractImportTemplate.xlsm
2. Generate CSV File
3. Import lease into Lease Accounting
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 |