Floating Rate Contracts Fail In Create Receivables Variable Rate Invoices Processing (Doc ID 2611119.1)

Last updated on JULY 14, 2020

Applies to:

Symptoms

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.

ERROR
---------
ORA-24381

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: <>
***Printing Report***
***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)



STEPS
-------------

The issue can be reproduced at will with the following steps:
1. Submit Create Receivables Variable Rate Invoices for different contracts.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.