My Oracle Support Banner

Terminate Expired Contracts Process Errors (Doc ID 1571798.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for relevance on 02-Aug-15

Symptoms

On : 12.1.3 version, Variable Interest Rate

When attempting to run Generate Accruals - Generate Accruals- Estimated and Billed process for converted contracts that are on Non Accrual Status.
the following error occurs.

ERROR
-----------------------
Multiple transactions exist for transaction number <TRANSACTION_NUMBER>.
Error occured while creating transactions for contract number: <CONTRACT_NUMBER>
Error occured while creating transactions for contract number: <CONTRACT_NUMBER>
Error Occured during the accrual catchup process for Contract Number <CONTRACT_NUMBER>

Then as a result, Terminate Expired contracts program errors out with the following:

Multiple transactions exist for transaction number <TRANSACTION_NUMBER>.
Error occured while creating transactions for contract number: <CONTRACT_NUMBER>
Error occured while creating transactions for contract number: <CONTRACT_NUMBER>
Unable to do reversal of non-income during termination of contract <CONTRACT_NUMBER>.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Take an expired converted loan contract that has some open invoices, contract is in non-accruing status, i.e., has not been paid for 120 days.
2. Pay all the open invoices and make sure there is no remaining amount. Contract should come out of non-accruing but it doesn't.
3. Run generate accruals - estimated and billed. It creates activities of reversal and catchup revenue but it errors out with the above.
4. Recycle the contract.
5. Run Terminate Expired contract and it errors out with the above errors.

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


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