C1-BLGEN Poor Performance In ORMB 2.5.0.3 (Doc ID 2289598.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 to 2.5.0.3.0 [Release 2]
Information in this document applies to any platform.

Symptoms

ORMB v2.5.0.3.0

ACTUAL BEHAVIOR
---------------
C1-BLGEN Poor Performance in ORMB 2.5.0.3
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.

EXPECTED BEHAVIOR
-----------------------
This should run faster.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run C1-BLGEN.


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