Partial Termination Stuck In "Working" Status Due to Pricing Failing (Doc ID 1322455.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.2 and later
Information in this document applies to any platform.
Checked for relevance 28-Junr-2015

Symptoms


On : 12.1.2 version, Generate Streams

Find that there are some lease contracts where partial termination quote has been created for each, the quotes are completed, however, the rebooking has failed. Termination transactions are stuck in Working status and the contracts are stuck in Passed status.

Pricing has failed for those contracts with the following error in the log file:

ERROR
-----------------------
Errors while processing Streams Results :-
ORA-01476: divisor is equal to zero in Package OKL_STREAM_GENERATOR_PVT Procedure prosp_adj_acc_strms
End Errors while processing Streams Results

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Contracts are stuck in Passed status after performing partial termination. Pricing has failed with the above exceptions.

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