While validating the EC Standard Report Compa Ratio and Range Penetration, customer gets an error message related to an association missing between Pay Range and another entity such as GeoZone, PayGrade or Legal Entity.
They receive a validation message similar to the following:
Table 'FOUNDATION_OBJECTS_VIEW_FO_OBJECT_RELATIONSHIPS_T_PAY_RANGE_LegalEntity (1)' is not found.
When you edit the query, you can also see the same error message and you are unable to edit the query.
- SuccessFactors HCM Suite
- SuccessFactors HCM Core
- SuccessFactors Employee Central - Advanced Reporting
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.
- Instance Validation
- See Error message.
There may be many causes for this happening:
- 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.
2136061 - How to determine which Pay Range is used in the Compa-Ratio and Range Penetration calculations - Employee Central
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