We have been upgraded to R12.1.3 and currently into first iteration.
When querying the old transaction from Transaction workbench window we get, ""The system cannot determine geographical information for this location and cannot derive a tax jurisdiction. Please contact your system Adminstrator" error.
I have run the "Geography Name Referencing Program" after getting this error. and that error got resolved.
Kindly Advice, "Geography Name Referencing Program", is it a part of upgrade process or we have to manually run the program.
Transaction Workbench Error: System cannot determine geographical information for this location and cannot derive a tax jurisdiction (Doc ID 438718.1)
Transaction Form Error: Querying or Creating a Transaction Raises Error: The system cannot determine geographical information for this location and cannot derive a tax juridiction. Please contact your system administrator. (Doc ID 1350601.1)
Geography Name Referencing Issue: Map_status for one location_id is 'E' in HZ_GEO_NAME_REFERENCE_LOG table (Doc ID 1368312.1)
I have seen the same document and ran the Geographu run referencing program. But my question here is, should we run this program immediately before releasing to Application team which is going to work on Applications
Have you reviewed the post concurrent programs which are kicked off as part of the upgrade process to verify if the concurrent program was completed successfully or not? The program will be submitted by the upgrade process (as mentioned in the doc that you have already reviewed) and if that's the case the point here is to verify if it completed successfully or not.
If the program ran successfully and you still hit the same issue then please review the docs in my previous reply. If the docs don't help then please log a SR.
If the program failed to run then you will need to run it manually.
If the program was never run by the upgrade then run it manually.
Srini Chavali-Oracle wrote:
If the upgrade process steps were followed correctly, this process should be run automatically by the upgrade. The fact that you have to run it manually indicates issues with the upgrade process you are following.
Not necessarily as the program might have failed to complete for some other reason
I'm surprised to see questions and answers in this thread which are addressed in the same MOS doc.