SAP Knowledge Base Article - Public

2361220 - How to map Picklist fields in EC Position Management to RCM Integration with oData API - Recruiting Management

Symptom

Error message received when attempting to create a Job Requisition from Position Management (Position Org Chart) if a Job Requisition field with type "Picklist" is included in the Business Rule Mapping.

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

Customers may request the possibility to use a picklist on the requisition side that is mapped to and prefilled from the position.

If this is the intended scenario, the OData API will require you to map the picklist values from MDF to the optionId of the picklist in RCM. When mapping a picklist to RCM, keep in mind that regardless of it is MDF or legacy picklist, you will be looking to find the OptionId of the picklist (Related KB article 2780148).

In order to do so, you will need to define this mapping with the help of an additional object that contains both the code and the optionId value.
The mapping object needs to be setup and maintained. Whenever there is a new value in the picklist, you will need a new instance of the object.

The MDF and the legacy picklist do not have to be manually kept in sync, as there is an automated way of doing so (see EC master guide, Q2 version, section 16.5 “Keeping ECV2 and MDF Picklists in Sync”).

Please find an example for such a picklist mapping:

Picklist Value External Code Option ID
Apple Apple_1 2001
Orange Orange_2 2002
Banana Banana_3 2003

To configure this in your system, execute the following steps:

  1. Create the mapping object in Configure Object Definitions, with only one custom field which is called “optionId”:
  1. Create a new instance of this object for every mapping. For the mass creation of all values of one or several picklists, it may be best to use the MDF import for the object(s): 
    Please note that there should no comma or decimal in the picklist Option ID.
  1.  Use the mapping object in the field mapping by performing a lookup via the external code:

NOTES:

  • Make sure that the optionID in the lookup table matches the optionID of the picklist in use in the Job Requisition Template. Otherwise, it will throw an error: "Sorry, the requisition cannot be created. Creation of a job for position POSITION1 failed. Details: FIELDID is invalid."
  • If the environment is Picklist Center, please create the rule using the field in RCM dot id, for example "filter1.id" in the screenshot below:

picklist center.jpg

See Also

2343638 - Unable to create Business Rules for Position Management to Recruiting Integration

2262815 - Succession Management: How do I migrate to or enable the MDF Position Model?

2079418 - Position Management - Employee Central

2780212 - Create Requisition from Position field invalid error for Picklist field - Recruiting Management

2780148 - How to map a picklist from EC Position to Recruiting Requisition - Recruiting Management

2885113 - How to find association fields in a lookup rule for Position Management

2878293 - Error when mapping picklist or object fields from EC to RCM through Position Management

Employee Central Master:
https://help.sap.com/viewer/b14dd15ca58f43e0856184a740a4b212/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Employee Central Position Management:
https://help.sap.com/viewer/cf23ba26985f4d4a8df3a34b7392847d/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Manage Pending Hires:
https://help.sap.com/viewer/11888ce8119846ecab730236b601aeb4/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Contingent Workforce Management:
https://help.sap.com/viewer/7b2dec4ed4d9459f893cce6f5920528d/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Keywords

Position Management, oData, API, Picklist, Business Rule, Job Requisition, is invalid, Sorry, the requisition cannot be created

, KBA , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-JOB , Job Postings & Requisitions , LOD-SF-RCM-INT , Integration Center & Intelligent Services , How To

Product

SAP SuccessFactors Recruiting all versions