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 APRIL 05, 2024
Applies to:
Oracle Fusion Global Human Resources - Version 11.1.11.1.0 and laterOracle 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |