On Demand Regular Billing is Creating Duplicate Billable Charges (Doc ID 2178314.1)

Last updated on SEPTEMBER 07, 2016

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 : ORMB 2.4.0.1.0 version, BI - Billing

ACTUAL BEHAVIOR
---------------
On-Demand Regular Billing is creating duplicate billable charges

On-Demand Billing- File uploaded through On-Demand Regular Billing created duplicate billable charges. Every line in the file should have created one billable charge each but some transaction lines created 2 billable charges with exactly same data. In the On Demand UI, it shows only one billable charge but CI_BILL_CHG table shows 2 billable charges. We compared the duplicate billable charges and it matches exactly with original billable charges (only difference is billable_chg_id). There are around 71 billable charges duplicated as of now due to ODB Regular Billing.

Below is the SQL query used to identify the duplicate billable charges,
select * from ci_bill_chg where adhoc_bill_sw = 'N' and feed_source_flg = 'API' and start_dt > '31-MAY-16' and start_dt < '01-JUL-16' and billable_chg_id not in (select billable_chg_id from ci_bchg_stg);

EXPECTED BEHAVIOR
-----------------------
On-Demand Billing. File uploaded through On-Demand Regular Billing should not create duplicate billable charges.

STEPS
-----------------------
The issue was reproduced with the following steps:
1. File uploaded through On-Demand Regular Billing.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This is high priority since the same charges have been billed twice for merchants.

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