- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Oracle Cloud HCM SaaS: Load Geography via HDL Errors
I am having issues loading Geographical data via HDL and keep getting the error:
The values The values Qala i Naw,AF-BDG,CITY,Afghanistan aren't valid for the attribute GeographyId.
I am using the below test file:
METADATA|GeographyHierarchy|SourceSystemOwner|SourceSystemId|Name|StatusCode|StartOnActivationFlag MERGE|GeographyHierarchy|HA|HA_AF|HA_AF|ORA_DRAFT|YES METADATA|GeographyHierarchyNode|SourceSystemOwner|SourceSystemId|HierarchyId(SourceSystemId)|CountryCode|Level1|Level2 MERGE|GeographyHierarchyNode|HA|HA_AF2|HA_AF|AF|AF-BDG|Qala i Naw
The country Afghanistan has been setup manually, and all tasks: Geocoding, Address Cleansing, Structure, Hierarchy, and Validation has been defined with a check mark. I am able to manually create a province and testcity. I already have state created in the Hierarchy.
I am not able to create individual states as well via HDL and get a similar error.
Any insight is appreciated.