Province/City/SAR Does not Exist in the Value Set JLZZ_STATE_PROVINCE (Doc ID 833007.1)

Last updated on JANUARY 09, 2015

Applies to:

Oracle Human Resources - Version 12.0.6 and later
Oracle Legal Entity Configurator - Version 12.0 and later
Information in this document applies to any platform.

Application Lookups
Legal Entity Configurator



NOTE: Issues/bugs for this belong to Product Code 1525>Oracle Legal Entity Configurator. Creation of Work Location addresses works properly in Core HR. The Oracle Legal entity Configurator does not recognize some city codes in the Application Lookups. See the resolution/workaround below.



Creating location addresses for via Legal Entity Configurator.

When we tried to create the location for the third enterprise of the six that we have to create, the following error was received:

ID BOGOTA D.C for the flexfield segment State does not exist in the value set JLZZ_STATE_PROVINCE

The issue can be reproduced at will with the following steps:

  1. Legal entity configurator>Setup tab
  2. Enter Legal Entity Location Address, including City name.
  3. Save
  4. Error:  ID BOGOTA D.C. for the flexfield segment State doesnt exist in the value set JLZZ_STATE_PROVINCEReceive Error: 


Implementation of 12.0.6


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