Here below is the format of the Location HDL file.
METADATA|Location|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|ShipToSiteFlag|BillToSiteFlag|OfficeSiteFlag|ReceivingSiteFlag|ShipToLocationCode|ShipToLocationSetCode|InventoryOrganizationName|LocationCode|LocationName|AddressLine1|AddressLine2|AddressLine3|Country|PostalCode|TownOrCity|MainphoneSubscriberNumber|OtherphoneSubscriberNumber|Description|Region1|Region2|Region3|SourceSystemOwner|SourceSystemId
MERGE|Location|COMMON|A|1901/01/01|4712/12/31|Y|Y|Y|Y||||00002|New Delih||Janakpuri|New Delhi India|IN|234432|Delhi|||Delhi||||EBS|HCM_LOCTAION_00002_XXTEST
Points to Ponder before loading Locations HDL file:
1. SourceSystemOwner and SourceSytemID must be unique for each location
2. Make sure SourcesystemOwner is setup in HCM lookup for example ‘EBS’
3. AddressLine1 and Postalcode are Mandatory and is enough to populate city and country by default.
4. Make sure the Meta Data columns should match with MERGE line Columns
