Tax Is Not Calculated Properly In Case Of Suppressed Billing

(Doc ID 1392766.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version: and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.


The problem is with Tax Calculation in Suppressed Billing Scenario.

Say, If the billing is suppressed for three months starting 01-Aug-201. On 01-Nov-2011 when the Bill is generated, the tax is not calculated properly.


Two entries in Table event_billing_taxes_t with the same OBJ_ID0 and REC_ID.

Sample Query to check:-

select ebi.amount, et.obj_id0,et.rec_id, et.amount 
from event_billing_taxes_t et,event_bal_impacts_t ebi
where et.obj_id0=ebi.obj_id0
and et.obj_id0 in 
(select poid_id0 from event_t where account_obj_id0=XXXXX);


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