My Oracle Support Banner

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

Last updated on OCTOBER 15, 2020

Applies to:

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


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.




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.