De-agg is Causing Cancelled Transactions to go Back into Upload Status

(Doc ID 2010931.1)

Last updated on APRIL 24, 2017

Applies to:

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


On : 2.3 version, OTH - Other Bugs

De-agg is causing cancelled transactions to go back into upload status.


The root cause for duplicate bill is a bad AUIF 2015-Jan transaction.  This was faced in February Month end billing.

1. Jan month end  in production, all  AUIF billable charges for MID level transactions are cancelled, and related transactions are set to ‘CNCL’ status ( ci_txn_detail table) . The corresponding billable charges were also cancelled. These were now dead transactions and will never be used.
2. Feb month end , when de-agg jobs are run, those AUIF transactions got updated to “UPLD” status by C1-PDTXN job ( CI_TXn_Detail table).
3. The above AUIF transactions get processed by TFM and billed for 2015-Feb billing cycle. This was not intended.



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