Searching for Vendor to Create Pass Through Details is Taking Long

(Doc ID 2391252.1)

Last updated on APRIL 25, 2018

Applies to:

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

Symptoms

On : 12.2.5 version, Lease Authoring

ACTUAL BEHAVIOR
---------------
Find that there is performance problem when searching for Vendor to create pass through details.

Reason for it to take long time is because in the session it is doing blank query on OKL_LA_PASSTHRU_VENDOR_UV

Query running was:
SELECT ORKhrEverGreenVendorEO.CPL_ID, ORKhrEverGreenVendorEO.OBJECT1_ID1, ORKhrEverGreenVendorEO.OBJECT1_ID2
  ,ORKhrEverGreenVendorEO.RLE_CODE, ORKhrEverGreenVendorEO.CLE_ID, ORKhrEverGreenVendorEO.DNZ_CHR_ID
  ,ORKhrEverGreenVendorEO.VENDOR_NAME, ORKhrEverGreenVendorEO.PAYMENT_HDR_ID, ORKhrEverGreenVendorEO.PYD_ID
  ,ORKhrEverGreenVendorEO.VENDOR_ID, ORKhrEverGreenVendorEO.PAY_SITE_ID, ORKhrEverGreenVendorEO.PAY_SITE_NAME
  ,ORKhrEverGreenVendorEO.PAY_GROUP_CODE, ORKhrEverGreenVendorEO.PAY_GROUP_NAME, ORKhrEverGreenVendorEO.PAYMENT_TERM_ID
  ,ORKhrEverGreenVendorEO.PAYMENT_TERM_NAME, ORKhrEverGreenVendorEO.PAYMENT_METHOD_CODE, ORKhrEverGreenVendorEO.PAYMENT_METHOD_NAME
  ,ORKhrEverGreenVendorEO.PAYMENT_FREQUENCY, ORKhrEverGreenVendorEO.PAYMENT_FREQUENCY_NAME, ORKhrEverGreenVendorEO.PAYMENT_BASIS
  ,ORKhrEverGreenVendorEO.PAYMENT_BASIS_NAME, ORKhrEverGreenVendorEO.PAYMENT_START_DATE, ORKhrEverGreenVendorEO.REMIT_DAYS
  ,ORKhrEverGreenVendorEO.DISBURSEMENT_BASIS, ORKhrEverGreenVendorEO.DISBURSEMENT_BASIS_NAME, ORKhrEverGreenVendorEO.DISBURSEMENT_FIXED_AMOUNT
  ,ORKhrEverGreenVendorEO.DISBURSEMENT_PERCENT, ORKhrEverGreenVendorEO.PROCESSING_FEE_BASIS, ORKhrEverGreenVendorEO.PROCESSING_FEE_BASIS_NAME
  ,ORKhrEverGreenVendorEO.PROCESSING_FEE_FIXED_AMOUNT, ORKhrEverGreenVendorEO.PROCESSING_FEE_PERCENT
 FROM OKL_LA_PASSTHRU_VENDOR_UV ORKhrEverGreenVendorEO


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a few Lease Vendors under contract parties
2) Navigate to Additional Charges to create usage or service line
3) Enter Service/usage details
4) For created service/usage line, Click on Create Pass Through Vendor
5) It navigates to Vendor Fee Details Page
6) Click on Vendor Lov and select any Lease Vendor
7) After selecting required Vendor, it takes around 5+ Minutes to display it back to the screen

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