On Demand Regular Billing is Creating Duplicate Billable Charges
Last updated on JUNE 13, 2018
Applies to:Oracle Financial Services Revenue Management and Billing - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : ORMB 126.96.36.199.0 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.
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