My Oracle Support Banner

Geography Name Referencing Output Shows Map_status for one location_id is 'E' in HZ_GEO_NAME_REFERENCE_LOG table (Doc ID 1368312.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


In this note we are going to use an example for Canadian location_id '804', but this note applies to any location where map_status is E in HZ_GEO_NAME_REFERENCE_LOG for table HR_LOCATIONS_ALL.
Due to this status, the tax does not get calculated when entering an invoice in Oracle Payables.

Steps to reproduce:

1. Run Geography Name Referencing Program with the following parameter:    

    -Location Table Name : HR_LOCATIONS_ALL
    -Run Type : All
    -Location ID From  : 804
    -Location ID To : 804 

2. Then run the script below:

MAP_STATUS                 LOCATION_ID                 LOCATION_TABLE_NAME
---------------------      -------------------         ------------------
E                          804                         HR_LOCATIONS_ALL




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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