My Oracle Support Banner

Workflow Background Process for OKLAMPPT is Running Long (Doc ID 2434101.1)

Last updated on AUGUST 13, 2018

Applies to:

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

Symptoms

On : 12.2.4 version, Lease Authoring


ACTUAL BEHAVIOR
---------------

Workflow background process for OKLAMPPT is running long

Request is stuck at the following sql statement:

SELECT NVL(SUM(NVL(AR.AMOUNT_DUE_REMAINING,0)),0) FROM AR_PAYMEN
T_SCHEDULES_ALL AR WHERE EXISTS ( SELECT 1 FROM RA_CUSTOMER_TRX_
LINES_ALL B, OKL_TXD_AR_LN_DTLS_B C, OKL_TXL_AR_INV_LNS_B D, OKL
_TRX_AR_INVOICES_B E WHERE B.INTERFACE_LINE_ATTRIBUTE10 = TO_CHA
R(C.ID) AND B.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS' AND INTER
FACE_LINE_ATTRIBUTE13 = 'TERMINATION_QUOTE' AND C.TIL_ID_DETAILS
 = D.ID AND D.TAI_ID = E.ID AND E.QTE_ID = :B2 AND E.KHR_ID = :B
1 AND B.CUSTOMER_TRX_ID = AR.CUSTOMER_TRX_ID ) AND AR.AMOUNT_DUE
_REMAINING > 0

EXPECTED BEHAVIOR
-----------------------

The above process should complete in reasonable time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Run Workflow background process for OKLAMPPT


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.