SAP Knowledge Base Article - Public

2607166 - Standard EC Report Compa Ratio and Range Penetration cannot be validated due to a missing table - ORD

Symptom

Standard EC Report Compa Ratio and Range Penetration fails to run and customers are unable to validate it when checking the report validator tool.

Environment

  • SuccessFactors HCM Suite
  • SuccessFactors HCM Core
  • SuccessFactors Employee Central - Advanced Reporting
  • SuccessFacrors Workforce Analytics

Reproducing the Issue

If using Report Center:

  1. Home
  2. Admin Center
  3. Click on Reporting & Analytics Icon
  4. Report Canvas Validation
  5. Validate Compa Ratio and Range Penetration
  6. See Error Message.

Analytics:

  1. Access the Analytics page
  2. Access the Analytics tab
  3. Access the report designer
  4. Find and edit the report Compa Ratio and Range Penetration
  5. Validate the report
  6. See the error message.

    Table 'FOUNDATION_OBJECTS_VIEW_FO_OBJECT_RELATIONSHIPS_T_PAY_RANGE_LegalEntity (1)' is not found. 

Cause

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:


PayRangeLegalEntity.png

Resolution

  1.  If this is the case, you will need to update your Corportate Data Model with the following association:
    1. <association id="id" multiplicity="ONE_TO_ONE" destination-entity="LegalEntity" required="false"/>. 
  2. 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. 
  3. 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. 
  4. Once the above is completed, validate the report and then you will be able to run/edit the report Compa Ration and Range Penetration. 

See Also

Installing and Validating Report – Canvas Templates

How to determine which Pay Range is used in the Compa-Ratio and Range Penetration calculations - Employee Central

Keywords

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

Product

SAP SuccessFactors Workforce Analytics all versions