My Oracle Support Banner

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

Last updated on MARCH 18, 2019

Applies to:

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


On : ORMB version, BI - Billing

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);

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

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

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


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.