My Oracle Support Banner

Billing BATCH JOB Performance SLOW (Doc ID 1664391.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version 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))


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

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