Cannot Update Brazil States Migrated from Release 11i to Release 12
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.
On : 12.2.3 version, Geography Hierarchy
You are attempting to query State AC, for Brazil, and receive the following 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'
Upgraded from Release 11i to Release 12
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms