SAP Knowledge Base Article - Public

2691716 - Position Sync from Integration Center

Symptom

How to sync Positions from BizX to Onboarding using Integration Center

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Onboarding

Resolution

Prerequisites:

  • An additional XSLT will need to be imported into Super Admin by the Operations team
  • Please follow the steps outlined in KBA:  2473170 Additional Corporate structure XSLT File-Onboarding, for this import.
  • Once that is completed, and the file is visible in the Super Admin UI

Create an additional Corporate Structure level

  1. Navigate to Super Admin
  2. Corporate Structure
  3. Add Level, enter level number, Title, Data Key for Level Code,
    Data Key for Level Name, check Show in UI, Show in User Profile, and Create
    Add Corporate Structure Level.png
  4. Navigate to BizX
  5. Admin Center
  6. Integration Center
  7. My Integrations
  8. Create, select 'Scheduled Simple File Output Integration'
    Create Position sync Report.png
  9. Search for Position
  10. Select it
    Search for Report.png
  11. Choose Code (code) String(128), and Job Title (jobTitle) String(255)
    Select fields.png
  12. Click next
  13. Output File Type is CSV, Header Type is Simple Header
    Select file type.png
  14. Click Next, on the Configure Fields remember the headings of the report as it will be used later
    Row headings.png
  15. Click Next, Filter and sort is optional
    Filter and sort.png
  16. Destination setting, SFTP host address(URL) and credentials will go on the File Server Setting
    File server settings.png
  17. File Name is a combination of ONBAcountID_Position_Sync, File Extension is CSV,
    File Folder by standard will be /ONB/inbound (where the folder is located in SFTP)
    Folder name and path.png
  18. For scheduling, choose when it occurs, and the Start Time (Must be a future date)
    Scheduled.png
  19. Click next and save

Before running the job, additional files must be configured.

  1. Navigate to Super Admin
  2. Import/Export Settings
  3. Export these 3 files ImportPosition, FoundationImport, and FoundationImportFieldMapping
  4. Open the file in a text editor
  5. In the FoundationImport
  6. Copy the Location section of the code, and edit it to suit the Position entity.
    Copy Location.png
  7. Change the ID from SuccessFactorsLocation to SuccessFactorsPosition
  8. Change the File Mask from {AccountName}_Location*.csv to {AccountName}_Position*.csv
  9. Change the ImportXslt name from ImportLocation.xslt to ImportPosition.xslt
  10. Change the field Name from Location to Position
    Edit to Position.png
    Note: the changes made in these areas is based on the title of that level in the corporate structure
  11. In the ImportPosition file
  12. Change the OrgLevel to the appropriate Org level for Position, in this example is 5
  13. The name of the variables in the ImportPosition file must be changed,
    the variables can be called anything, but they do have to match the variables in the FoundationImportFieldMapping
    Edit ImportPosition.png
  14. In the FoundationImportFieldMapping
  15. Copy the Location section
  16. Change the name from SuccessFactorsLocation to SuccessFactorsPosition
    Edit FoundationImportFieldMapping.png
  17. The Keys must match the variable in the ImportPosition XSLT.
    In the example below, they are Name and ClientID. The value must match the row heading of the report.
    Row headings excel.png
  18. Save all files and import them back in Super Admin

Keywords

Foundation Import, Position Sync, Corporate Structure Sync , KBA , LOD-SF-OBD-INT , Integrations with Onboarding , How To

Product

SAP SuccessFactors Onboarding all versions