C1-TXNIP Batch Processes Transactions of Any Status Including EROR from CI_TXN_DETAIL_STG Table (Doc ID 2130550.1)

Last updated on APRIL 28, 2016

Applies to:

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

Symptoms

On RMB 2.3.0.2 version, Transaction Feed Management:

Recently the environment was upgraded to ORMB version 2.3.0.2.0 from 2.3.0.0.0. One specific issue during the C1-TXNIP batch execution that was working in 2.3.0.0.0 environment.

Actual Behavior
--------------------
In TFM, once the transactions are loaded in CI_TXN_DETAIL_STG table, and the C1-TXNIP batch is executed, the batch picks the transactions irrespective of the status of the transactions. There are transactions in error status in this table and the IP batch picked and processed these transactions as well which was not expected.

From the code of this batch, below query is found which fetches the transactions for initial product derivation.

StringBuilder queryString = new StringBuilder("SELECT L_ID, H_ID AS H_ID FROM ( SELECT * FROM (select ROWNUM AS ROW_INDEX, L_ID, H_ID from (SELECT TXN_DETAIL_ID as L_ID, LEAD(TXN_DETAIL_ID, ?) OVER(ORDER BY TXN_DETAIL_ID) AS H_ID FROM CI_TXN_DETAIL_STG WHERE TRUNC(TXN_DTTM) <= ? AND DISAGG_SW = ? ");

  if (!isBlankOrNull(this.parmTransactionHeaderId)) {
  queryString.append(" and TXN_HEADER_ID =? ");
  }
  if (!isBlankOrNull(this.parmTransactionSource)) {
  queryString.append(" and TXN_SOURCE_CD =? ");
  }
  if (!isBlankOrNull(this.parmDivision)) {
  queryString.append(" and CIS_DIVISION =? ");
  }
  queryString.append("ORDER BY TXN_DETAIL_ID )) where MOD(ROW_INDEX, ?) = 1 ) ");

ERROR
-----------------------
There is no error for this task.
It just processes all transactions in CI_TXN_DETAIL_STG table including the ones with 'EROR' status.
This behavior seems incorrect.

BUSINESS IMPACT
-----------------------
IP batch does not consider the status of the transactions while picking up from the CI_TXN_DETAIL_STG table.
Need to know if this is bug or working as per design.

Changes

Upgrade to ORMB version 2.3.0.2.0 from 2.3.0.0.0.

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