C1-BLGEN Poor Performance In ORMB 220.127.116.11
Last updated on JULY 27, 2017
Applies to:Oracle Financial Services Revenue Management and Billing - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2]
Information in this document applies to any platform.
C1-BLGEN Poor Performance in ORMB 126.96.36.199
Testing environment is composed of 2 application server cluster, 9 batch server cluster and 2 database server cluster. Each batch server has 4 thread pool workers with 8 threads each. We have executed the base billing jobs in this environment to generate trial bills where the billing mode is set as 'Trial'. About 1,881,949 trial bills were successfully generated by C1-PNDBL. And then 3,727,857 trial bill segments were successfully generated by C1-BLGEN but it took almost 1 hour to complete using 280 threads. This is unacceptable for Visa RPA's limited critical window for its entire nightly batch stream. After extracting the AWR Report, a SELECT statement of C1-BLGEN was seen with a large elapsed time. Please provide solutions to both 'Trial' and 'Actual' billing modes even though this issue was found in 'Trial' mode of C1-BLGEN.
This should run faster.
The issue can be reproduced at will with the following steps:
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