City Jurisdiction is Not Found for Some Locations (Doc ID 1926579.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

City jurisdiction is not found for 4 locations.

Flat file from Commerce Clearing House (CCH) looks like this:

1.  The following are the two (2) city jurisdiction records:

060010402565350-2                20060101        1    1    AZSEDONA                        Y0Y
060010402565350-1                20060101        1    1    AZSEDONA                        Y1Y

2. The following are the zipcode records:

080010402565350-1                20060101201012311    11   8633686336SEDONA                        
080010402565350-1                20110101        11   11   8633686336SEDONA                        
080010402565350-1                20060101201012311    11   8634086340SEDONA                        
080010402565350-1                20110101        11   11   8634086340SEDONA

080010402565350-2                20060101        19   19   8634186341SEDONA                        
080010402565350-2                20060101        19   19   8635186351SEDONA        -------> value on the customer record                
080010402565350-2                20060101        19   19   8633686336SEDONA    

3. The following is the rate records for city:

090010402565350-1                20060101201012311    2    00300000ACITY  
090010402565350-1                20110101        2    2    00300000ACITY  

The zip code on the sample transaction is:

INFO:-Returned Postal Code : 86351

When you process with the customer Inner City checked, on the customer record, you are not getting a city line due to the zip code of 86351 that is attached to the Outer City jurisdiction, not the Inner City jurisdiction.

So, for not getting a rate for both Inner City check and not checked is correct because checking the 'Inner City' on the customer record is wrong due to the zipcode per CCH records is attached to '-2' (the Outer City juridiciton).

The '-2' city jurisdiction is only being looked at.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.