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 JULY 12, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms