Load Work Structure using HCM Data Loader
In earlier blog we have seen how to define Source Keys and we have created "XXTEST".
We will use the same Source Key while loading the HCM Object in Oracle Fusion.
You can see step by step video using this link
Now we will see how to load Work Structure Components in Oracle Fusion using HCM Loader.
Work Structure Components :
- Grade
- Job
- Location
- Organization
- Position
Download the object template from instance.
Navigation to download :
Navigator -> My Client Group -> Data Exchange -> View Business Objects
You can see list of all object template.
Download the template for Work Structure Objects.
We will use only required fields from that template to load the Work Structure Object.
Lets see object wise HDL File.
Grade :
METADATA|Grade|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|GradeCode|GradeName|ActiveStatus
MERGE|Grade|XXTEST|XXTEST_GRADE01|1951/01/01|4712/12/31|COMMON|XXTEST_GRADE01|XXTEST Grade01|A
Highlighted in Yellow are the Source Keys used to load.
Save file as "Grade.dat"
Job:
METADATA|Job|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|JobCode|Name|ActiveStatus|RegularTemporary
MERGE|Job|XXTEST|XXTEST_JOB1|1951/01/01|4712/12/31|COMMON|XXTEST_CFO|XXTEST: Chief Financial Officer|A|R
Save file as "Job.dat"
Location :
METADATA|Location|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|LocationCode|LocationName|Description|ActiveStatus|AddressLine1|AddressLine2|TownOrCity|Region1|Region2|PostalCode|Country
MERGE|Location|XXTEST|XXTEST_LOC5|1951/01/01|4712/12/31|COMMON|XXTEST_LOC5|XXTEST Location5|XXTEST Location6|A|250 Some st1||Pasadena|Los Angeles|CA|91101|US
Save file as "Location.dat"
Organization :
Organization has 2 components to load:
1) Organization
2) Org Unit Classification
METADATA|Organization|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|Name
MERGE|Organization|XXTEST|XXTEST_DEPT1|1951/01/01|4712/12/31|XXTEST Department1
METADATA|OrgUnitClassification|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|OrganizationId(SourceSystemId)|ClassificationCode|SetCode|Status
MERGE|OrgUnitClassification|XXTEST|XXTEST_DEPT_CLASS1|1951/01/01|4712/12/31|XXTEST_DEPT1|DEPARTMENT|COMMON|A
Save file as "Organization.dat"
Position :
METADATA|Position|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PositionCode|Name|BusinessUnitName|ActiveStatus|JobId(SourceSystemId)|DepartmentId(SourceSystemId)|HiringStatus|PositionType|FTE|HeadCount|FullPartTime|WorkingHours|Frequency
MERGE|Position|XXTEST|XXTEST_POISITION1|1951/01/01|4712/12/31|XXTEST_POS1|XXTEST Position1|US1 Business Unit|A|XXTEST_JOB1|XXTEST_DEPT1|APPROVED|NONE|1|1|FULL_TIME|40|W
Save as "Position.dat"
Make zip file including all object's HDL File.
Load the zip file in Oracle Fusion
Navigator -> My Client Group -> Data Exchange -> Import and Load -> Import
Import the prepared zip file.
Refresh to see the status of loading.
Once Loaded successfully, you can verify the Work Structure.
You can see step by step video using this link
In Next Blog we will see how to load Worker Data in Oracle Fusion Using HCM Data Loader.
Hi,
ReplyDeleteI see there are many objects in dat file in the Metadata line as compare to what you showed in the video, so my Q is "if these dat files have been changed over course of time or the columns you showed in your video are the mandatory one's.....?"
Please confirm.
Also please share contact details if possible.
Thanks
Hello,
DeleteHope you are doing well.
Yes there are many objects/attributes in metadata line but I showed only those what are the required to upload the data in fusion system.
If you want to find the required/mandatory ones then you can find these details in View Object and click on Object Name.
Always it is required to download the template from oracle because in case any version changes as mentioned by you will be capture in those dat files.
You can contact me on hcmfusion12988@gmail.com
Hi Sourabh,
DeleteFirst of all, thank you very much for the videos and those are really helpful.
I need your Help when I Tried to Import data from the Position it is giving me the Load Error as mentioned below. can you please help me to solve this errors:
1. No objects can be loaded because no valid objects exist. Review the error messages, correct the data, and resubmit the data in a new file.
2. The record referenced by the foreign key attribute {ATTR} wasn't found. Either specify a valid foreign key or create the referenced record first.