Fusion Global HR: HCM Data Loader (HDL): Updating Location Address with Blank Address Line Copying the Previous Line (Doc ID 2185111.1)

Last updated on NOVEMBER 07, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.11.1.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Address Line 3 for locations incorrectly populated when loaded via HDL

Loading two lines of information for location one with Address line 3 and top of the stack without address line 3. But when this information is loaded in Fusion both the rows have AddressLine 3 populated which is incorrect.

Below is the sample data:

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|LOC1|HRC_SQLLOADER|4/1/2000|12/31/4712|COMMON||A|||||||||||||||Y||Y|Y|Y|||||LOC_CODE|Location_Name|Location_description|Addr1|||PO ZIP||US|||45241|Reg1|Reg2|||Town1
MERGE|Location|LOC1|HRC_SQLLOADER|1/1/1901|3/31/2000|COMMON||A|||||||||||||||Y||Y|Y|Y|||||LOC_CODE|Location_Name|Location_description|Addr1||Add3|PO ZIP||US|||45241|Reg1|Reg2|||Town1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms