Transaction Workbench Error: Creating a Transaction Raises Error: APP-ZX-426037: The System Cannot Determine Geography Name Reference for Location & LOCATION_TYPE (Doc ID 1590914.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

Attempting to create a transaction for a customer with a Canadian address and receive the following error:

Error
APP-ZX-426037:The system cannot determine geography name reference for location & LOCATION_TYPE

Map Status of the customer location in table hz_geo_name_reference_log is in ERROR
.

Running the following shows MAP_STATUS = E (Error):

Noted fields listed below:
LOCATION_ID COUNTRY ADDRESS1              CITY       POSTAL_CODE PROVINCE
----------- ------- --------------------- ---------- ----------- --------
4210984     CA      1    PRINCE PHILIP DR ST. JOHN'S A1B 3R3     NL  

Customer diagnostic shows in HZ_PARTIES (Customer Account):

PARTY_ID   PARTY_NUMBER   PARTY_NAME                       COUNTRY  ADDRESS1               CITY         POSTAL_CODE      PROVINCE    STATUS   
---------- -------------- -------------------------------- -------- ---------------------- ------------ ---------------- ----------- ------
15500020   8901671        College of the North Atlantic    CA       1 PRINCE PHILIP DR     ST. JOHN'S   A1B 3R3          NL          A

 

 

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