SAP Knowledge Base Article - Public

3728531 - Integration Center pulls only one record of one-to-many relationship during full data query - Recruiting Management

Symptom

By design, Integration Center is unable to return all records from a one-to-many relationship. It will always return just one record of the navigation entity.

A workaround is available, that is, creating an XML output file to query all records of one-to-many associations in Integration Center.

However, in jobReqiusition to JobRequisitionOperator to userNav association, even XML output file returns just one record during full-load query. On the other hand, when pulling data of specific Job Requisition ID, all records are populating to the XML output file.

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1. Follow KBA 3082922 to create an XML output file to query all records of one-to-many associations in Integration Center
  2. Start the Integration Center from jobRequisition entity
  3. Include one-to-many association by adding JobRequisitionOperator (e.g. recruiterTeam)
  4. Then add another association to pull email from userNav navigation entity
  5. Run the job and check the XML file
  6. Notice that for every job requisition, only one user of recruiterTeam is pulled and one email
  7. Add a filter so that the job will pull data from specific Job Requisition ID, then run the job
  8. Notice that the XML file includes all user of recruiterTeam and their email

Cause

Product Managers confirmed this behavior is a known limitation of Integration Center when handling one-to-many associations during full-load queries. It occurs due to the way Integration Center processes OData navigations in batch executions compared to single-record queries.

Resolution

If there's a need to extract all recruiterTeam email addresses per job requisition, use jobRequisitionOperator as the root object instead of jobRequisition in the Integration Center configuration.

See Also

  • 3087941 - One-to-many behavior in Integration Center
  • 3082922 - How to configure an integration with an XML output file to query all records of one-to-many associations in Integration Center

Keywords

integration center, jobRequisitionOperator, full-load processing, recruiter email, one-to-many associations, recruiterTeam , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem

Product

SAP SuccessFactors Recruiting all versions