Please follow the below steps to load a country and country geography structure using File Import process in Oracle HCM Cloud system :
Country Load :
Step 1 : Create a text file in the below format to load country as per your requirement. Sample file below.
CountryCode,LevelNumber,GeographyType,GeographyTypeName
IN,1,COUNTRY,Country
IN,2,STATE,State
IN,3,CITY,City
Step 2 : Steps to load Country Structure in Cloud :
Navigate to Home --> Setup and Maintenance --> Tasks --> Manage File Import Activities
Step 3 : Now under Manage Import Activities, click on the '+' button. Enter a name and for Object select Country Structure.
Leave file Type as Text with File section as specific file. Upload your text file from local with Data Type as csv header included.
Step 4 : Now click next and in the Map fields region, set the Object to ImpGeoStructureLevel. Set the Attribute with the correspondingColumn Header
Step 5: Now click next and schedule the Import process.
Country Geography Hierarchy Load :
Step 1 : Create a text file in the below format to load country hierarchy as per your requirement. Sample file below.
RecordTypeCode,GeographyType,PrimaryGeographyName,CountryCode,LevelNumber,SourceId,ParentSourceId,PrimaryGeograpgyCode
0,COUNTRY,Colombia,CO,1,1,,
1,STATE,ANTIOQUIA,CO,2,2,1,05
1,CITY,ABEJORRAL,CO,3,3,2,013
Step 2 : Steps to load Country Hierarchy in Cloud :
Navigate to Home --> Setup and Maintenance --> Tasks --> Manage File Import Activities
Step 3 : Now under Manage Import Activities, click on the '+' button. Enter a name and for Object select Geography.
Leave file Type as Text with File section as specific file. Upload your text file from local with Data Type as csv header included.
Step 4 : Now click next and in the Map fields region, set the Object to ImpGeoStructureLevel. Set the Attribute with the correspondingColumn Header
Step 5: Now click next and schedule the Import process.
