Terminate Expired Contracts Process Errors (Doc ID 1571798.1)

Last updated on MARCH 08, 2017

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 2448436.
Error occured while creating transactions for contract number: 702-2221CR
Error occured while creating transactions for contract number: 702-2221CR
Error Occured during the accrual catchup process for Contract Number 702-2221CR

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

Multiple transactions exist for transaction number 2448436.
Error occured while creating transactions for contract number: 702-2221CR
Error occured while creating transactions for contract number: 702-2221CR
Unable to do reversal of non-income during termination of contract 702-2221CR.


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.

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