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 and later
Information in this document applies to any platform.


On RMB version, Transaction Feed Management:

Recently the environment was upgraded to ORMB version from One specific issue during the C1-TXNIP batch execution that was working in 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.

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.

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.


Upgrade to ORMB version from


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

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