Billing BATCH JOB Performance SLOW (Doc ID 1664391.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.2.0 and later
Information in this document applies to any platform.

Symptoms

The BILLING batch program takes a very long time to finish in certain scenarios.

A SQl like this cost high CPU resource from ADDM/ASH report:
select count(*) as col_0_0_ from CI_FT financialt0_ where (financialt0_.SA_ID in(select serviceagr1_.SA_ID from CI_SA serviceagr1_ where(serviceagr1_.ACCT_ID=:1 )))and(financialt0_.BILL_ID=' ')and(financialt0_.FREEZE_SW=:2 )and(financialt0_.SHOW_ON_BILL_SW=:3)and(financialt0_.FT_TYPE_FLG not in(:4 , :5 , :6 , :7))

Cause

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