My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2020

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.

Symptoms

For Canadian location_id '804', 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

Cause

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
Symptoms
Cause
Solution
References


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