Tax Is Calculated Multiple Times In Case Of Multiple Cities with Similar Names (Doc ID 2120723.1)

Last updated on APRIL 12, 2016

Applies to:

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

Symptoms

On :  7.5.0.14.0 version, Taxation

ACTUAL BEHAVIOR  
---------------
While calculating tax for city like "PIERRE" , the other similar city like "FORT PIERRE" are also included in the calculation and hence instead of calculating 2%tax for city PIERRE , additional  2% is also getting applied.

Sample details
  salestax: U : 2.0  : 02/01/01 : 01/31/20 : Cit : FORT PIERRE;FREEMAN;GARRETSON;GAYVILLE;GEDDES : Sales-Cit : Std
  salestax: U : 2.0  : 02/01/01 : 01/31/20 : Cit : PIERRE;PLANKINTON;PLATTE;PRESHO : Sales-Cit : Std

cm.pinlog:
       Taxcode salestax has valid rate!
D Thu Apr  7 20:14:23 2016    cm:30802  fm_cust_pol_tax_calc.c:454 2:.pin_trial_bill_accts:30793:-172483728:1123:1458747254:1:root.0.0.0.1:::
        Locale PIERRE is in juris list 'DEADWOOD;DELL RAPIDS;DELMONT;DIMOCK;EAGLE BUTTE;EDGEMONT;ELK POINT;ELKTON;EMERY;ESTELLINE;EUREKA;FAIRFAX;FAITH;FAULKTON;FLANDREAU;FLORENCE;FORT PIERRE;TEST PIERRE;FREEMAN;GARRETSON;GAYVILLE;GEDDES' for taxcode salestax
...
...
...
...
D Thu Apr  7 20:14:23 2016 . cm:30802  fm_cust_pol_tax_calc.c:454 2::pin_trial_bill_accts:30793:-172483728:1123:1458747254:1:root.0.0.0.1:::
        Locale PIERRE is in juris list 'MOUND CITY;MT VERNON;MURDO;N SIOUX CITY;NEW EFFINGTON;NEWELL;NEW UNDERWOOD;NISLAND;NORFOLK;OACOMA;OAKES;ONIDA;PARKER;PARKSTON;PHILIP;PICKSTOWN;PIERPONT;PIERRE;PLANKINTON;PLATTE;PRESHO' for taxcode salestax

EXPECTED BEHAVIOR
-----------------------
In the above sample scenario, It should calculate  2% tax for city "PIERRE"


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