Standard EC Report Compa Ratio and Range Penetration fails to run and customers are unable to validate it when checking the report validator tool.
- SuccessFactors HCM Suite
- SuccessFactors HCM Core
- SuccessFactors Employee Central - Advanced Reporting
- SuccessFacrors Workforce Analytics
Reproducing the Issue
If using Report Center:
- Admin Center
- Click on Reporting & Analytics Icon
- Report Canvas Validation
- Validate Compa Ratio and Range Penetration
- See Error Message.
- Access the Analytics page
- Access the Analytics tab
- Access the report designer
- Find and edit the report Compa Ratio and Range Penetration
- Validate the report
- See the error message.
Table 'FOUNDATION_OBJECTS_VIEW_FO_OBJECT_RELATIONSHIPS_T_PAY_RANGE_LegalEntity (1)' is not found.
The most common cause for this is when there is no associaition being maintained in the Corportate Data Model between Pay Range and Legal Entity:
- If this is the case, you will need to update your Corportate Data Model with the following association:
- <association id="id" multiplicity="ONE_TO_ONE" destination-entity="LegalEntity" required="false"/>.
- Once this is done, you will need to add data for Legal Entity for at least one Pay Range to validate the association so that it is picked up in Advanced Reporting.
- Finally, you will need to raise a ticket with support requesting a metadata reload as there were recently changes made to your EC configuration that need to be reflected in Advanced Reporting.
- Once the above is completed, validate the report and then you will be able to run/edit the report Compa Ration and Range Penetration.
EC Standard Reports, Report Transfer, Report Center, Advanced Reporting, Import Reports, ODS, Realms, Corportate Data Model, , Configuration, Employee Central, Compa Ratio, Legal Entity, Table 'FOUNDATION_OBJECTS_VIEW_FO_OBJECT_RELATIONSHIPS_T_PAY_RANGE_LegalEntity (1)' is not found, FOUNDATION_OBJECTS_VIEW_FO_OBJECT_RELATIONSHIPS_T_PAY_RANGE_LegalEntity , KBA , LOD-SF-EC-ROD , Reporting/Analytics (ODS) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , Problem