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

• 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"

SAP SuccessFactors HXM Suite

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"

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

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

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

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