You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

HDL error loading Location

in HCM Data Loader (HDL) 4 comments

This is the Location.dat we used to load.

METADATA|Location|SourceSystemId|SourceSystemOwner|EffectiveStartDate|EffectiveEndDate|SetCode|LocationImageURL|ActiveStatus|MainphoneAreaCode|MainphoneCountryCode|MainphoneExtension|MainphoneSubscriberNumber|FaxAreaCode|FaxCountryCode|FaxExtension|FaxSubscriberNumber|OtherphoneAreaCode|OtherphoneCountryCode|OtherphoneExtension|OtherphoneSubscriberNumber|OfficialLanguageCode|EmailAddress|ShipToSiteFlag|ShipToLocationId|ReceivingSiteFlag|BillToSiteFlag|OfficeSiteFlag|DesignatedReceiverId|InventoryOrganizationId|GeoHierarchyNodeId|GeoHierarchyNodeCode|LocationCode|LocationName|Description|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|Country|FloorNumber|LongPostalCode|PostalCode|Region1|Region2|Region3|TimezoneCode|TownOrCity

MERGE|Location|LOCWCBAB|WHRAPS|1900/01/01|1916/12/31|WCB||A|||||||||||||US||Y||Y|Y|Y|||||AB|Abbotsford Area Office|Abbotsford Area Office|123 Street|||||CA|||V9V 1A1|British Columbia|BC|||Abbotsford

Value for Region1 = British Columbia

Value for Region2 = BC

This used to work fine, but after we setup Province Hierarchy in "Manage Geographies", HDL errors with "You need to enter a valid province, city, or postal code for the address."

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!