2665276 - Report Using Job Information Position Column Shows Incorrect Object Codes in Employee Central

When creating an Table/adhoc Report and using the Job Information column or an Advanced report using the Position column from Global Job Information table, incorrect object codes appear:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HXM Suite

Scenario 1:

1. Create an Adhoc report using Person and Employment Info (as of Date) domain.
2. Select Job Information Position Column Generic object entities e.g. Company, Division, Department, Job Code.
3. Run online or extract the report.

4. Result (Observe the codes listed from the report highlighted in Yellow and red):

Scenario 2:

1. Create a Canvas report
2. Advanced Reporting
3. Select Employment
4. Global Job Information table
5. Select the Position column

The internalId/internalCode of the MDF object data is being fetched instead of the externalCode:

1. Take a sample output for e.g. Company - 804012

2. Go to Configure Object Definitions > Object Definition > Legal Entity > search for the internalId field > & set the visibility to Read Only:

3. Add internalId as a searchable field for Company/Legal Entity MDF Object:

4. Search for Company/Legal Entity - 804012 from Manage Data:

Note: This is also true for other Domain Types like Succession (MDF Position based nominations), Job Information (Date Range), & other domains accessing employee MDF data from EC HRIS elements.

• This is a known limitation with Ad Hoc Reports and Global Job Information table that are pulling data from MDF object fields. By design, fields from the position object, with a generic object data type fetch numerical values instead of labels/descriptions in Ad Hoc reports / Global Job Information (Canvas) .
• Enhancing this for Ad Hoc framework will cause huge performance degradation for all the reports of this schema for all customers.

Workaround:

• The Advanced Reporting feature should be leveraged in this scenario to generate the same report (The Position external code and name will be available in the Position table).
• The ODS report can be configured to return the Code/Name values instead of the internalCode value.
• This is the recommended tool for reporting on Employee Central data.

sf, success factors, EC, internalId, internalCode, job info, ad hoc, position, ECT-83833 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC-POS , Position Management , Problem