My Oracle Support Banner

Funding UI - SUBMIT AND APPROVE have Performance Issue (Doc ID 2360844.1)

Last updated on FEBRUARY 20, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On ORMB 2.5.0.3.0 version, Funding UI - SUBMIT AND APPROVE buttons have performance issue.

When monitoring the DB, we found the below query was taking around 370 seconds when submitting a funding request for approval.

select vw.bill_id, vw.acct_id, vw.currency_cd, NVL( vw.curr_bill_bal,0 ) as
 curr_bill_bal, dtls.funding_dtl_id as funding_dtl_id, NVL(
 dtls.garnish_amt, 0) as garnish_amt , NVL(dtls.funding_amt, 0) as
 funding_amt, NVL(FN_GET_HOLD_AMT_FOR_BILL (vw.bill_id, vw.curr_bill_bal,
 'FNDG' ), 0) as hld_amt
from
C1_BILL_DTLS_VW vw, c1_funding_req_dtls dtls where dtls.bill_id =
 vw.bill_id and trim(dtls.rec_status_flg) = trim(:1 ) and funding_req_id =
  :2 /* Get Funding Details */

We expect that the platform has to support 40,000 bills in Funding in < 1 min (SUBMIT / APPROVAL). For the current phase go-live, we are expecting 2000 bills in funding request.

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.