SAP Knowledge Base Article - Public

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

Symptom

  • Cross domain Ad Hoc Report of Recruiting V2 and Employee Profile Domain does not fetch records
  • Ad Hoc Report is blank when creating cross domain report between Recruiting V2 and Employee Profile 
  • Cross Domain Ad Hoc 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

  •  Ad Hoc Report Builder

Reproducing the Issue

  •  Go To Ad Hoc Report > Create > Select Cross Domain > Choose Recruiting V2
  • Add Employee Profile Domain
  • Select few columns from "Candidate" table under Recruiting module 
  • Select few columns from "Employee Information" table under Employee Profile module
  • 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

  • Report appears as blank 
  • OR, Report returns very less number of records

Cause

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

Resolution

To Justify this is Data Issue Please follow below steps:

Step 1:

  1. Create a single domain ad hoc 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 ad hoc 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 Ad Hoc Report of Recruiting V2 and Employee Profile

Keywords

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

Product

SAP SuccessFactors HCM Core all versions