Performance Issue When Running Batch Job C1-TXNRP
Last updated on FEBRUARY 21, 2018
Applies to:Oracle Financial Services Revenue Management and Billing - Version 188.8.131.52.0 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.
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