SAP Knowledge Base Article - Public

2433258 - Cross domain Table Report of Recruiting V2 and Employee Profile Domain does not fetch records

Symptom

  • Cross domain Table Report of Recruiting V2 and Employee Profile Domain does not fetch records
  • Table is blank when creating cross domain report between Recruiting V2 and Employee Profile 
  • Cross Domain Table report of Recruiting and EP is not fetching expected result when join is present between "Candidate: User Sys ID" and "Employee: User Sys ID"

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Go To Report Center > Table report > Create > Select Cross Domain > Choose Recruiting V2
  2. Add Employee Profile Domain
  3. Select few columns from "Candidate" table under Recruiting module 
  4. Select few columns from "Employee Information" table under Employee Profile module
  5. Under "Relationship" tab select as below:
    • "Candidate: User Sys ID" Inner Join "Employee: User Sys ID"

OR

    • "Candidate: User Sys ID" Left Outer Join "Employee: User Sys ID"

Recruiting Cross Domain Ad Hoc.png

  1. Report appears as blank 
  2. OR, Report returns very less number of records

Cause

 This is data issue which does not satisfy the criteria present under Relationship tab in Table Report.

Resolution

To Justify this is Data Issue Please follow below steps:

Step 1:

  1. Create a single domain Table report of Recruiting V2 domain 
  2. Fetch "User Sys ID" column from "Candidate" table 
  3. Export the report

Step 2:

  1. Create a single domain table report of Employee Profile Domain 
  2. Fetch "User Sys ID" from "Employee Information" table
  3. Export the report

Step 3:

  1. Now match and compare both exported report output
  2. Find out how many User Sys IDs are matching
  3. Common "User Sys IDs" present in both report should appear in the Cross Domain Table Report of Recruiting V2 and Employee Profile

Keywords

Cross Domain, Recruiting V2, Employee, Profile, Relationship, Inner Join, Left Outer
, KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HXM Suite all versions