Cannot Update Brazil States Migrated from Release 11i to Release 12 (Doc ID 1984801.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, Geography Hierarchy

You are attempting to query State AC, for Brazil, and receive the following error:

ERROR
-----------------------
Value for identifier_subtype must be a value defined in lookup type HZ_GEO_IDENTIFIER_SUBTYPE.

Geography data shows:
GEOGRAPHY_ID IDENTIFIER_TYPE IDENTIFIER_SUBTYPE IDENTIFIER_VALUE LANGUAGE_CODE
108871 CODE FIPS_CODE            AC US
108871 NAME SECONDARY_NAME   AC US
108871 NAME STANDARD_NAME     AC US

In the lookups table, CODE FIPS_CODE, STANDARD_NAME,SECONDARY_NAME are valid lookup code.

But lookup code  'SECONDARY_NAME' is end-dated.

Steps to Reproduce:
Responsibility: Trading Community Manager
Navigation: Administration > Geography Hierarchy
Search for country code 'BR'
Click on Structure icon
Search for State code 'AC'

Changes

Upgraded from Release 11i to Release 12

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