My Oracle Support Banner

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


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