Performance Issue When Running Batch Job C1-TXNRP (Doc ID 2084321.1)

Last updated on DECEMBER 01, 2015

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

There is a performance Issue when running batch job C1-TXNRP

When the pricing refresh is done for all accounts (~300K) and all new pricing tables are populated, upon executing the job for a single division, the batch tries to delete the entries from CI_PRC_PL using the following query: DELETE FROM CI_PRC_PL PA WHERE EXISTS (SELECT 1 FROM CI_ACCT A WHERE A.ACCT_ID = PA.ACCT_ID AND A.CIS_DIVISION = :B1 ),
This query takes around 1hr and 30mins to complete as they are monitoring the job. Once completed the batch is finished in 2mins.

The issue can be reproduced at will with the following steps by running batch job C1-TXNRP against a large number of customers

Since C1-TXNRP will be running for each CIS Division in every preliminary billing cycle this will be a big performance problem.

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