System cannot determine geographical information for this location and cannot derive a tax jurisdiction when entering an transaction [ID 438718.1] 438718.1] In this Document
Sympto ms Caus e Solutio n Referenc es Applies to:
Oracle Payables - Version 12.0.0 and later Oracle E-Business Tax - Version 12.0 and later Oracle Trading Community - Version 12.0 and later Oracle Receivables - Version 12.0.0 and later Information in this document applies to any platform. Symptoms
E-Business Tax (EBTax) Information Center > Jurisdicti Jurisdictions ons & Geographies > Note 438718.1 Customer receives error while attempting to create an invoice for a customer: System cannot determine geographical information for this location and cannot derive a tax jurisdiction, please contact your system administrator
. Cause
The geography geography hierarchy hierarchy did not exist for the the customer user was try to enter an transaction on
Had the customer run the following statement and the results returned E even after the Geography Name Referencing Program had been run. select map_status, location_id from hz_geo_name_reference_log where location_id = &location_id;
Solution
To implement the solution, please execute the following steps: I. II. III.
First check if there is a value for profile option HZ :Generate Party Number, if so please do following: For the ship-to/bill-to which is failing navigate to the customer form and look up the particular ship-to/bill-to record. Please make note of the site number Run the following queries to determine the location_id which is failing select party_site_id, party_id, location_id from hz_party_sites where party_site_number = '&site_number';
select location_id, country, address1, address2, address3, city, postal_code, state, county from hz_locations where location_id = &location_id;
IV.
once you have the valid location id, then run this query
select map_status, location_id from hz_geo_name_reference_log where location_id = &location_id;
Map_status S means that the location_id is successfully created. Map_status E means that the location_id has not been successfully created.
V.
Navigate to Trading Community Manager -> Administration -> Geography Hierarchy Click on Manage Validations, and find the geography mapping and validations. . For eg: State, County, City, Postal Code Verify if tax validation and geography validation is enabled for each of the segments
VI.
In the customer form, query the customer in question and review the ship-to, bill-to addresses The format you selected under the geography hierarchy must match what you have entered under each bill-to, ship-to for example if you are missing the county and you have selected to have this segment validated under the geography hiearchy, you must have this field entered for the ship-to, bill-to under the customer. You can use the standard TCA API to update the customer address (County information in this case): PL/SQL Package Name: HZ_LOCATION_V2PUB Procedure: update_location Parameter: County Please review the following documentations for more details information on TCA API: 1) Oracle® Trading Community Architecture Technical Implementation Guide Release 12 Part No. B25895-01 Chapter 5: Person and Organization Information, Location, and Party Site API Use / Location APIs Update Location API Page 5-42 2) Note 201243.1: Using TCA API's Including Examples
VII.
Once steps have all been verified rerun the Geography Name Referencing Program again using the location_id as the parameter.
VIII.
Rerun this query once more
select map_status, location_id from hz_geo_name_reference_log where location_id = &location_id;
The map_status should now be S Once you have done this, please recreate the invoice and verify that issue has now been resolved References
@NOTE:1384591.1 - Enter invoice errors with "The System Cannot Determine Geographical Information For This Location" @NOTE:469332.1 - Cannot Derive A Tax Jurisdiction When Entering When Entering Transaction @NOTE:1377318.1 - Create Debit Memo Errors with 'The System Cannot Determine Geographical Information For This Location'
