Revolving Loan: Accrual Program Ending In Error (Doc ID 2173006.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Agreement Modules

The Generate Accrual program for Revolving loans is completing normally. But the log file for this program indicates as:

NS Revolving 010, Error Status : U
ORA-06502: PL/SQL: numeric or value error in Package OKL_GENERATE_ACCRUALS_PVT Procedure CREATE_ACCR_LINE_FORMULA
Error occured during the create accrual process for Contract Number NS Revolving 010.

Due to this, no accrual transactions are being created for this contract
 

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error in Package OKL_GENERATE_ACCRUALS_PVT Procedure CREATE_ACCR_LINE_FORMULA




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a 'Revolving' Credit Line
2. Create a 'Revolving' Loan contract - and associate the above Credit Line
3. Create a 'Borrower Payment' Funding request for the above contract
4. Validate, Approve and Pay the AP Invoice for the above Funding request
5. Process the 'Loan Balances Update' program
6. Process the CRVRI Program for the above contract
7. Process the Billing program for the contract
8. Process the 'Generate Accrual' program for the contract



Changes

 

Cause

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