Floating Rate Contracts Fail In Create Receivables Variable Rate Invoices Processing
(Doc ID 2611119.1)
Last updated on JULY 14, 2020
Applies to:Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Billing Modules
Floating Rate contracts fail in Create Receivables Variable Rate Invoices processing
Several loan contracts are failing during the Create Receivables Variable Rate Invoices process with errors.
kle_id : <>
sid:90422997: Exception raised in procedure POPULATE_VIR_PARAMS
Exception during bulk insert
Exception count : 1
while fetching, error 1 occurred during iteration 4
oracle error is User-Defined Exception
sid:90422997: Error raised in call to INSERT_VIR_PARAMS
sid:90422997: Exception var_int_loan_float_failed raised in procedure VARIABLE_INTEREST_LOAN_FLOAT
sid:90422997: Error raised in call to VARIABLE_INTEREST_LOAN_FLOAT
sid:90422997: Exception process_int_float_failed raised in procedure PROCESS_INTEREST_FLOAT
sid:90422997: Error raised in call to PROCESS_INTEREST_FLOAT
Error 1: Unexpected error. (SQLCODE=-24381) (SQLERRM=ORA-24381: error(s) in array DML)
End Processing for Contract Number: <>
***End of Processing***
End Debug OKLPVARB.pls call OKL_VARIABLE_INTEREST_PVT.VARIABLE_INTEREST
sid:90422997: 1: Unexpected error. (SQLCODE=-24381) (SQLERRM=ORA-24381: error(s) in array DML)
The issue can be reproduced at will with the following steps:
1. Submit Create Receivables Variable Rate Invoices for different contracts.
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