Funding UI - SUBMIT AND APPROVE have Performance Issue
Last updated on FEBRUARY 20, 2018
Applies to:Oracle Financial Services Revenue Management and Billing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On ORMB 184.108.40.206.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
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.
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