BIP Tax Jurisdiction Report not Showing the City Name Wise Classification

(Doc ID 2164116.1)

Last updated on APRIL 17, 2017

Applies to:

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

Symptoms

On :  7.5.0.14.0 version, Portal Reports

When a Tax Jurisdiction summary report is executed, it does not show the TAX JURISDICTION classified by CITY. It shows the report as UNKNOWN CITY.
The data within the EVENT_TAX_JURISDICTIONS_T had all the data as per expectation.  The Package BIP_TAXES.GET_JURISDICTION seems to be returning the output wrongly.

STEPS
-----------------------
- Have taxes configured at the state and city level in BRM.
- Associate the respective tax code in the product.
- Create accounts. Purchase products.
  Note that the cycle charges and any usage and purchase charges applied are taxed.
- Run billing
- Login to BIP and try running the Tax jurisdiction report for city taxes the report shows up as the attached pdf file.
  It does not show individual city information. It shows as "UNKNOWN CITY" . The database EVENT_TAX_JURISDICTION_T has the correct information


Changes

 

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