My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

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


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:

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

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.


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

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