Value Alberta for the flexfield segment Province does not exists in the value set HZ_CA_PROVINCES_2 (Doc ID 1981074.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Geography Hierarchy

Customer is trying to update the address for Canadian customers with the province Alberta and the following error appears:

ERROR
-----------------------
Value Alberta for the flexfield segment Province does not exists in the value set HZ_CA_PROVINCES_2


Steps to Reproduce:
Responsibility:  Receivables Manager
Navigation:  Customers> Customers
Create customer with address in province Alberta

SETUP FOR ADDRESS DFF FOR CANADIAN ADDRESSES:
Descriptive Flexfield Definition
Application Receivables
Title Address
Prompt Context Value
Required not checked
Displayed not checked
Synchronize with reference Field not checked
Code POSTAL_ADDR_CA
Name POSTAL_ADDR_CA
Description Canadian Address Style
Enabled

Value Set
Name Province
Window Prompt Province
Column PROVINCE
Value Set HZ_CA_PROVINCEs_2

Segment Address – POSTAL_ADDR_CA
Value Set HZ_CA_PROVINCES_2
Validation Table Information
Table Application Receivables
Table Name HZ_GEOGRAPHIES
Where/Order by :
Where geography_type=’PROVINCE’ and country_code=’CA’  and state >=start_date and sysdate<=nvl(end_date,sysdate) order by geography_code

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