Province/City/SAR Does not Exist in the Value Set HR_CN_PROVINCE (Doc ID 832951.1)

Last updated on FEBRUARY 03, 2015

Applies to:

Oracle Human Resources - Version 12.0.5 and later
Oracle Legal Entity Configurator - Version 12.0.5 and later
Oracle General Ledger - Version 12.0.5 and later
Information in this document applies to any platform.
Application Lookups
Legal Entity Configurator


When attempting to use LOCATION QUERY on ZTS Legal Entity where China International address type used the CN_PROVINCE the following error occurs:

Province/City/SAR does not exist in the value set HR_CN_PROVINCE flexfield segment

Steps to Reproduce

The issue can be reproduced at will with the following steps:
     1.  Legal entities were defined, using the Accounting Setup Manager page.

     2.  Checked form, Create New Address (legal address). Address was created.

     3.  When this address is queried an error message is received due to the value entered for the county.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot query the Legal address that was defined earlier


Upgrade to R12.0


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