Tax Is Not Calculated Properly In Case Of Suppressed Billing (Doc ID 1392766.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

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

Goal

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.

Symptoms:
----------------

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

Solution

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