2648522 - Error Message Occurred When Running Person and Employment Info (as of Date) Report

• You would receive an application error when running Person and Employment Info (as of Date) report  Online and Offline (Export or download).
• The application error id would be accompanied by the fingerprint id = 9e0aafead962313f319b06882ba307e3ec0251e0

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 Employee Central -Ad-hoc reports

1. Go to Adhoc report 
2. Select Sub- Domain Person and Employment Info (as of Date) Report
3. Create report
4. Save 
5. Run report  Online and Offline (Export or download)
6. Result: errorId=b190ad5e-141e-4dee-a6f8-edb5873c6b7c, fingerprint=97214ccd98f20c6be17730981c5c81b792e0fea2, timestamp=2019-05-29T21:42:07.068-0400)

• This is a known issue with the EC Ad Hoc domain in Ad Hoc wherein the maximum join depth limit is being reached when the HANA database runs a query.
• The report has columns from multiple country-specific Job Information and Personal Information tables.

• The report query becomes too large for the system to execute as it involves multiple countries. Ideally, fields from only 2 countries’ Job Information should be included in one adhoc report. However, the number of countries depends on the volume of data.
• Customer Action:

1. AS Customer do not have access to Provisioning, Please contact Employee Central Support Engineer Team.
2. Open an case with component: LOD-SF-EC-REP

• Employee Central Support Engineer Team Action:

1. Please refer to Internal Meno 
2. Go Provisioning
3. Company Settings
4. Check if the following feature was enabled: Enable Cell Level Permissions on "Group by Reports" [Can be used for demo, not ready for production]
5. Disable the feature and use switch instead : Enable Cell Level Permissions on "Group by Reports V2" [Demoable, Not Ready for Production]

• Please see the following KBA for more information on this feature: 2080162 - Employee Central: Ad Hoc Report Types Explained

ECT-89279,  Person and Employment Info (as of Date) report, fingerprint=9e0aafead962313f319b06882ba307e3ec0251e0, 9e0aafead962313f319b06882ba307e3ec0251e0, Adhoc report, cross domain, ECT-99304, Maximum, trimming, AYT-24278, group by reports v2, provisioning switch, Enable Cell Level Permissions on "Group by Reports" [Can be used for demo, not ready for production], SQL internal parse tree depth exceeds its maximum: join depth exceeds its maximum: , KBA , person and employment info (as of date) , cross domain , enable cell level permissions , group by reports , internal parse tree depth exceeds , join depth exceeds its maximum , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Suite all versions