C1-FIBCR SQL Query Bad Performance
(Doc ID 3054869.1)
Last updated on NOVEMBER 06, 2024
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 5.1.0.0.0 to 5.1.0.0.0 [Release 5.0]Information in this document applies to any platform.
Symptoms
C1-FIBCR Query performing bad
Query performing bad SQL ID : 123456789 which corresponds to query:
SELECT billable_chg_id , '0' as CALC_AMT , '0' as currency_cd
from CI_BILL_CHG b
where billable_chg_stat = :1 and :2 between start_dt and end_dt
and priceitem_cd =:3 and sa_id = :4
and EXISTS ( SELECt 1
from CI_BILL_CHG_CHAR c
where c.CHAR_TYPE_CD=:5
and c.SRCH_CHAR_VAL = :6
and c.billable_chg_id = b.billable_chg_id ) /* Check exisitng entry for billable charges */
As a result, batch performance has degraded.
The SQL query baseline did not work due to incorrect query implementation.
It took 55 minutes to complete one thread, which ideally should finish in 5 minutes.
Changes
No changes.
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 |
| Changes |
| Cause |
| Solution |
| References |