Billing BATCH JOB Performance SLOW
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.
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))
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