My Oracle Support Banner

Geography Hierarchy: State LOV does not show entire State name but only abbreviation. Entire State Name should appear in LOV but only State Abbreviation code stored in Address record (Doc ID 2376170.1)

Last updated on MARCH 15, 2024

Applies to:

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


Release 12 version, Geography Hierarchy has been set up but the LOV for the STATE Field in the address contains the abbreviated STATE name and not the entire STATE name.

Address Validation for State not displaying entire state name but only the abbreviated state name.    ie: MH and not Maharashta is displayed for the state name.
 can successfully use the LOV on the customer address form to create a new address and select a state from the LOV and save. However, when we go back to the record - the page throws an error indicating the value we just picked (and can pick again) is invalid.

State enable validation should occur without error.   Full state name should display in the LOV (list of values) but only the state abbreviated code should write to the address form and to the record created for HZ_LOCATIONS.




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.