Human Capital Management Blogs by Members
Gain valuable knowledge and tips on SAP SuccessFactors HCM suite and human capital management market from member blog posts. Share your insights with a post of your own.
cancel
Showing results for 
Search instead for 
Did you mean: 
kaylatoelle
Active Participant
3,145
Recently, I’ve had several questions about syncing your corporate structure relationships.  When I saw the Import Relations xslt file in Super Admin, I had the same question. Like I said in my previous post, I have been the one to maintain the onboarding structure before, so I am always looking for a way to improve a user’s experience and decrease the level of maintenance required to support the module.

The below example will walk you through the steps for syncing your corporate structure relationships.

Determine Corporate Structure Levels

In Onboarding, go to Onboarding > Reference Files > Corporate Structure



OR

In Super Admin, go to See Also > Corporate Structure

Creating the Integration Center Report

1. Go to Admin Tools > Company Settings > Integration Center and select click My Integrations


2. Click the Create button and then select Scheduled Flat File Output Integration


3. Search for “Department” and select Department (FODepartment)
4. Select Department (externalCode) and the parent code. (It could be under Navigations)
5. Uncheck Start Date
6. Click Select



7. Enter Integration Details

  • Integration Name: Onboarding Relations Export

  • Output File Type: csv

  • Header Type: Simple


8. Click Next
9. Click the child code and change the label to ChildID
10. Click the parent code and change the label to ParentID


11. Click ChildID and select Insert Field > Insert Fixed Value Field (You can create a calculated field to calculate count but for demo purposes, we will use a fixed value field)

  • Label: ChildOrgLevel

  • Default Value: 3 (Your child corporate structure level)


12. Click OK



13. Repeat steps to create ParentOrgLevel

  • Label: ParentOrgLevel

  • Default Value: Your Parent Level (In this demo, it’s 2)


14. Click OK



Your report should now look like this:



15. Click Next
16. Expand the Advanced Filters section and click Browse
17. Search and select ‘Status (status) in Department (FODepartment)’
18. Click Change Association to “Status”



19. Enter A in the Value field to only include Active Departments
20. Click Next


21. Enter Destination Settings

  • Enter SFTP Server Host Address, username, and password

  • File Name Prefix: <case sensitive Company ID>_Relations_Sync

  • Date Suffix Format: yyyyMMdd

  • File Extension: csv

  • File Folder: /ONB/Inbound


22. Click Save



Modify the Foundation Import File

1. In Super Admin, Go to Integration > Import/Export Settings
2. Under the Integration section, export the FoundationImport file.
3. Save a backup of the file
4. Add the below code right above the last </FoundationImportConfiguration>



5. Save as a new file
6. Return to Import/Export Settings in Super Admin and import the new foundation import file
Modify the Foundation Import Field Mappings

1. In Super Admin, Go to Integration > Import/Export Settings
2. Under the Integration section, export the FoundationImportFieldMapping file.
3. Save a backup of the file
4. Add the below code right above the last </FoundationImportFieldMapping>



5. Save as a new file
6. Return to Import/Export Settings in Super Admin and import the new foundation import field mapping file

Run the Integration Center Reports

1. In Provisioning, go to Manage Scheduled Jobs
2. Find your Relations Sync Report and select Run Now from the Actions drop down

Check Import Status in Onboarding Audit Report

1. Once your report has been picked up from the ftp site, the file should no longer be listed in the       inbound folder.

2. Other than checking your corporate structure, you can determine the status of the import by           going to Onboarding > Settings > Audit Report

3. Select the blank option from the Type dropdown, enter INTEGRATION in the Event Code                 textbox and click filter

4. Find the import file and see if it is complete

Once your report runs successfully and is processed by Onboarding, your corporate structure relations will be available in Onboarding


Once again, I hope this post will make managing your Onboarding Corporate Structure a little easier. Please stay tuned for part three on syncing position and additional attributes.
11 Comments
Labels in this area