My Oracle Support Banner

Customers Workbench: View Customer Error - Value MO For The Flexfield Segment State Does Not Exist In The Value Set HZ_US_STATE (Doc ID 1642171.1)

Last updated on OCTOBER 13, 2022

Applies to:

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


In R12.1.3:

After converting customers using Oracle Public APIs, users get the following error message for US customers when viewing a customer:

Error Message
Value MO for the flexfield segment State does not exist in the value set HZ_US_STATES

The issue only happens for customers that are upgraded from 11i.

There are no issues for customers that are created in R12.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Customers > Customers
-Query for a customer
-Click n Account Details icon
-Click on the Details icon for the address.
-Under Account Site Address region, the error appears right below the State field.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.