IAENT Job is Disaggregating Transaction in Cancelled Billable Charges

(Doc ID 2221961.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

On : 2.4.0.1.0 version, BI - Billing

ACTUAL BEHAVIOR
---------------
The IAENT Job is disaggregating transaction in canceled billable charges

When the billing monthly is run and during, the billing, we cancel few billable charges which should not be billed to Merchants. Therefore every month, we have canceled billable charges. When IAENTis run, it is disaggregating all the canceled billable charges transactions. Visa should not bill the transactions which has canceled billable charges.

Scenario:
- Have canceled billable charges since 01-Jan-15
- Billing jobs run every month and few billable charges are canceled.
- We want to run de agg for a month so if we are running billing for Nov 16 then it should include transactions from 1st Oct 16 till 31st Oct 16

Issues:
1. When we run IAENT job for Oct month so the disagg from date should be 1st Oct 16 but the batch fails, stating, “Deagg from date would impose partial disagg for some billable charges”. It should allow us to disagg from 1st Oct and ignore the transactions which has canceled billable charges.
2. After deagg(if we give de agg from date as 01 Jan 15 which is like more then 1 year transaction) the canceled billable charge status is in canceled but all the transactions in this billable charge are copied to ci_txn_detail_stg table. So when we run TFM these transactions are again getting aggregated with a new billable charge. So now we have 2 billable charges one canceled billable charge and one new billable charge. Ideally, we should not bill these transactions to Merchant.
 

EXPECTED BEHAVIOR
-----------------------
 Ideally, we should not bill these transactions to Merchant.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Have canceled billable charges since 01-Jan-15.
- Billing jobs run every month and few billable charges are canceled.
- We want to run de agg for a month so if we are running billing for Nov 16 then it should include transactions from 1st Oct 16 till 31st Oct 16.

BUSINESS IMPACT
-----------------------
We should not bill these transactions to Merchant.

Changes

 

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