REST API to Retrieve info from Manage Geography Hierarchy (HZ_GEOGRAPHIES,HZ_GEOGRAPHY_IDENTIFIERS)

11:40AM

Summary:

We are looking for a supported REST API to retrieve Country, State details from the Manage Geography Hierarchy in Oracle Fusion.

Currently, geography-related data such as country, state is stored in the tables HZ_GEOGRAPHIES and HZ_GEOGRAPHY_IDENTIFIERS. We need to retrieve attributes like:

Geography name (Country/State)

Identifier values like Primary/alternate codes maintained under the State Hierarchy

Is there any existing REST API in Oracle Fusion that can be used to retrieve all above details from the Manage Geography Hierarchy?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

REST API to Retrieve info from Manage Geography Hierarchy (HZ_GEOGRAPHIES,HZ_GEOGRAPHY_IDENTIFIERS)

Howdy, Stranger!