Error when Creating Principal Paydown on Contract with Partial Termination

(Doc ID 2317443.1)

Last updated on OCTOBER 13, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Lease Authoring

When creating a Principal Paydown on a Contract that has a partial termination, getting an error as ‘APP-FND-01934: ORA-06502: PL/SQL: numeric or value error in Package OKL_LA-STREAM_PVT Procedure EXTRACT_PARAMS_PPD_REBOOK’

When clicking on OK for the above message, the next error shows up as ‘APP-OKL-442306: Extraction of contract information in stream generation process failed.

This issue does not happen on a similar contract that does not have a partial termination on it

Error Codes
---------------------------------------------------
APP-OKL-442306: Extraction of contract information in stream generation process failed


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Lease Super User responsibility
2. Create a Fixed Rate Loan Contract with a start date of 14-Dec-2015 and a term of 36 months
3. Add multiple assets to this contract. In our example – we have 6 assets on the contract
4. Add an Income fee for $1500
5. Create ‘RENT’ payment in Arrears for each of the asset on the contract
6. Validate and Book the Contract
7. Process Billing till 15-Apr-17
8. Process Accrual for 31-Mar-17
9. Create a Partial Termination quote for 1 asset on the contract.
10. Term quote effective from date = 18-Apr-17. Term Type: Termination Without Purchase. Termination Reason: Repossession
11. Approve and Complete the quote
12. One asset is now terminated on the Contract
13. Navigate to Lease Center Manager and query the Contract
14. Create a Principal Paydown for the contract. Paydown Date: 18-Apr-17, paydown amount = 25,000, Pricing = Revise Payments
15. For the PPD, click on ‘Calculate Payment’. Status of the PPD changes to ‘Complete’
16. Now click on ‘Accept Paydown’
17. We get the first error message as ‘APP-FND-01934: ORA-06502: PL/SQL: numeric or value error in Package OKL_LA-STREAM_PVT Procedure EXTRACT_PARAMS_PPD_REBOOK’.
18. Click on OK for the above message – and we then get the next message as ‘APP-OKL-442306: Extraction of contract information in stream generation process failed’

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