OBTFPM|14.5.3.0.0|Performance Issue| Bill List Enquiry Slowness (Doc ID 2874197.1)

Last updated on JUNE 10, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
bill list enquiry is taking more than 3 minute in OBTFPM and 9 MIN in OBDX(Multiple CIF)

we have noticed below query is taking lot of time

SELECT MIN(MATURITY_DATE)
  INTO P_WRK_IFDTFBCL.V_BCVWS_MASTER_DATA.FROM_MAT_DATE
  FROM BCVW_CONTRACT_LIST;

Also BCVW_CONTRACT_LIST also take more time for multiple customers which creates slowness in case enquiry is done from OBDX.

EXPECTED BEHAVIOR
-----------------------
The enquiry operation should be fast.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enquire about any bill contract in OBDX
2. Verify the time taken to retrieve the data from OBTF and OBDX
3. Do the same operation in OBTFPM
4. Verify how long it is taken in OBTFPM and OBTF

Cause

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