My Oracle Support Banner

C1-BLPPR Batch Job | Making Redundant Calls To COBOL Converted Java Class, Causing Performance (Doc ID 2676025.1)

Last updated on JUNE 04, 2020

Applies to:

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

Symptoms

On : 2.6.0.1.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------

C1-BLPPR Batch Job | Making Redundant Calls to COBOL Converted Java class, causing performance bottleneck.

It is observed that override bill due date calculation algorithm gets called from CustomerClassAutoPayRuleEvaluationAlgComp_Impl for each FT that has been frozen. Upon closer look it was noticed that AutoPay algorithm invokes  :

billDueDate = cobolCopybookBBLDC.get_OUTPUT_WRK().get_DUE_DT();

Which means if bill has 92576 bill segments then this process will get called for 92576 times making redundant calls to database for same account and pull back same date, resulting in performance bottleneck.

As a part of analysis while putting loggers in the algorithm (which calculate bill due date) and ran the process. it was seen that the same set of data getting invoked for 92576 times.

Below is the decompiled version of code from CustomerClassAutoPayRuleEvaluationAlgComp_Impl

Date billDueDate = bill.getDueDate();
  if (!SessionHolder.getSession().isOnlineConnection()) {
  Date billDate = getProcessDateTime().getDate();
  CobolProgramCIPBBLDC cobolProgCIPBBLDC = new CobolProgramCIPBBLDC_Impl();
  CobolCopybookCICBBLDC cobolCopybookBBLDC = cobolProgCIPBBLDC.getCobolCopybookCICBBLDC();
  INPUT_WRK inputBBLDC = cobolCopybookBBLDC.get_INPUT_WRK();
  inputBBLDC.set_ACCT_ID(accountId.getTrimmedValue());
  INPUT_OUTPUT_WRK inputOutputWrkBBLDC = cobolCopybookBBLDC.get_INPUT_OUTPUT_WRK(); //THIS IS CALLED FOR N' times for N' no of FT's getting FREEZED
  inputOutputWrkBBLDC.set_BILL_DT(billDate);
  cobolProgCIPBBLDC.callCobol();
  billDueDate = cobolCopybookBBLDC.get_OUTPUT_WRK().get_DUE_DT();
  }
  if (isNull(billDueDate)) {
  return;
  }

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.