My Oracle Support Banner

Acceptance WF Get Stuck with SQL - OKL_AM_QUOTES_WF.pre_proceeds_trmnt_contract API (Doc ID 2796648.1)

Last updated on JANUARY 03, 2022

Applies to:

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

Symptoms

On : 12.2.3 version, Asset Management

ACTUAL BEHAVIOR
---------------
Find that on some partial terminations, the quote acceptance workflow gets stuck with SQL - OKL_AM_QUOTES_WF.pre_proceeds_trmnt_contract API.

When the quote is accepted, the events are going to WF deferred queue. When these events are starting to process, they are getting stuck with below SQL

begin OKL_AM_QUOTES_WF.pre_proceeds_trmnt_contract (:v1, :v2, :v3, :v4, :v5); end;

EXPECTED BEHAVIOR
-----------------------
Expect to be able to successfully accept and complete the quote.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using Lease super user responsibility, create a contract with multiple assets.
2. Book and bill the contract.
3. Create a partial termination quote and approve and accept. Quote does not complete.


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
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.