My Oracle Support Banner

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.


Attempting to create a transaction for a customer with a Canadian address and receive the following 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:
----------- ------- --------------------- ---------- ----------- --------
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




To view full details, 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 a vibrant support community of peers and Oracle experts.