SAP Knowledge Base Article - Public

2646086 - How to extract Job Requisition Descriptions using Integration Center - Recruiting Management

Symptom

  • Sometimes users have a need to extract job requisition descriptions, however, this action is not possible using an ad-hoc report.
  • In the past, this action could be accomplished just by using SFAPI.
    • See KB article 2253326 - Create Report to Include "External Job Description" within a Job Requisition for more information.
  • With the advent of Integration Center and the addition of some specific entities to handle the job description, the user can use the Integration Center to accomplish this task.
  • This KB article explains the steps to make this extraction a file.

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 Recruiting Management

Resolution

In order to extract all job descriptions, follow the steps below:

  1. Open Integration Center > My Integrations > Scheduled Simple File Output Integration:

j1.png

  1. Select the JobRequisitionLocal entity and select all the fields that you want to include in the file. If you want to make a simple extraction, just use the External/Internal Job Description and the Job Requisition Id.

j2.png

Here is a preview of how the information will be extracted:

j3.png

Pay attention to the format displayed here. Since it is an extraction directly from the database, it will also contain the HTML tags that format the content in the browser. There is no way to extract the description without this information.

  1. Provide the desired name, add a filter as required*, and set the SFTP information. This information will be used to save the output file:

j4.png

On the screen above select the file extension, and a suffix as the date, to help organize the files in case you need to extract this file more than once.

Pay particular attention to the Output File Type selected. If the output file doesn't match what is expected, try changing this to an alternative value. What is needed changes for each customer and integration. 

● CSV: standard comma-separated value readable by Microsoft Excel and most text editors.

● True CSV: CSV file type that accommodate special characters such as carriage returns, new lines, double quotes, commas.

  1. Ignore Double Quotes For Null Values : To remove double quotes for fields with Null Values

● Simple Delimited: uses delimited formatting that uses different characters to separate data values such as commas, tabs, and colons.

  1. File Delimiter : A delimiter which is used in the file
  2. Use Double Quotes : To force quotes around all fields

● Simple Fixed Field Width: the width of each field is determined by the maximum number of characters specified for that field.



After configuring everything, save the integration and go to the Review and Run tab. Here review the SFTP information where the integration will create the file. If everything is correct, just click Run.

Webp.net-compress-image.jpg

When the execution is completed, you will have a file with all the job requisition descriptions.

Note: Due to the entity limitation, there is no way to filter the information based on the attributes of the job requisition entity as status, etc. You will only be able to filter the information on the fields presented in jobRequisitionLocal as Job Req Id, for example.

See Also

KBA 2253326 - Create Report to Include "External Job Description" within a Job Requisition

KBA 2621968 - Different Output Types for Simple File Output Integration available in Integration Center 

Keywords

Job description extraction, requisition, RCM, SF, success factors , KBA , LOD-SF-RCM , Recruiting Management , How To

Product

SAP SuccessFactors Recruiting all versions