My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.3.0.0.0 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.



ERROR
-----------------------
There is no error for this task.
It just processes all transactions in CI_TXN_DETAIL_STG table including the ones with 'ERROR' 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

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.