Page 1 of 1
Error During Export from Transaction summary
Posted: Thu Sep 03, 2009 12:52 am
by EMANUEL
Hi,
We are trying to do Export from Receivables >> Transactions >> Transactions Summary whereby we are facing the Error
?The system cannot determine geographical information for this location and cannot derive a tax jurisdiction. Please contact your system administrator.?
Please suggest the resolution for this
Rgds
Posted: Thu Sep 03, 2009 1:54 am
by tgs100
The same issue is reported in some of the metalink ids. You may go through 602353.1, 420194.1
Cheers,
Saravanan TG
Posted: Thu Sep 03, 2009 6:01 am
by EMANUEL
HI,
There are various solutions given in the related notes. whereby I tried to follow one i.e.
==============================================
Navigate to Trading Community Manager ->
Requests -> Run
Select "Geography Name Referencing" program
Processing for Table : HZ_LOCATIONS and Run Type : ALL
Parameters: Country Code :
Usage Code :ALL
From Location Id :NULL: To Location Id:NULL
Start Date :NULL: End Date:NULL
Number of workers:1
==============================================
The output showed the results:
Total number of Processed Locations:17211
Number of Successfully Processed Locations:118
Number of Locations in Error:17093
also the output for many records was like mentioned below
"Current Location ID: 186
The address cannot be validated because no geography mapping exists for this country. Please contact your system administrator.
Current Location ID: 188
The address cannot be validated because no geography mapping exists for this country. Please contact your system administrator.
Current Location ID: 190"..........................
can you suggest which action plan shall I follow as the issue is still there
Rgds
Posted: Thu Sep 03, 2009 6:34 am
by tgs100
My suggestion is to log a service request with oracle as the issue should be analyzed to give a proper solution.
Cheers,
Saravanan TG