SAP Knowledge Base Article - Public

2674214 - Pay Component Group is Not Accessible Through Manage Organization Pay and Job Structure

Symptom

  • Pay Component Group Are Not Visible in Manage Organization Pay and Job Structure
  • Pay Component Group is  not Accessible through Manage Organization Pay and Job Structure
  • Pay Component Group is not migrated in Check Tool

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

Environment

  • SAP SuccessFactors Employee Central
  • Foundation Objects

Reproducing the Issue

Please see Example of issue below

First troubleshoot 

  1. Go to Admin tool- Check tool
  2. Select EC Core-Run
  3. Result: Invalid Effective End Date check for FO/GO

222Dateformat.png

Second troubleshoot  

  1. Admin Center
  2. Manage Organization, Pay and Job Structure 
  3. Pay Component Group 
  4. Result: Base Salary cannot be found (not even as inactive) 


Third troubleshoot

  1. Import Foundation Data 
  2. Pay Component Group 
  3. Import the respective Pay Component Group correcting the effective end date. 
  4. Result:System returns a message that the pay component group does not exist 
  5. Monitor job result: This operation has led to unique key constraint violation


Fourth Troubleshoot

  1. Manage Organization, Pay and Job Structure. 
  2. Create new 
  3. Pay component group 
  4. Pay Component Group ID = Base Salary 
  5. Result: System returns "Code Already Exists" or Is Migrated = No

Cause

Foundation Object migration at the Data base level

Resolution

SuccessFactors Engineering team will need to run a script to migrate the Foundation Object at the Data base level. So Please contact Employee Central Support and provide the Following:

  1. Create a case for: LOD-SF-EC-FOO
  2. Provide a written approval for the script

Employee Central Support Team Please refer to Internal note  (Open a jira and Add The queries to be executed)

The queries to be executed are as following:

update <<company_schema>>.FO_PAY_COMPONENT_GROUP_T

set EFFECTIVE_END_DATE = to_date('31-DEC-9999', 'DD-MON-YYYY') 
where code in ('AnnualizedSalary', 'Base Salary'); 

update <<company_schema>>.FO_PAY_COMPONENT_T 
set EFFECTIVE_END_DATE = to_date('31-DEC-9999', 'DD-MON-YYYY') 
where code in ('Base Salary');

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Check Tool

See Also

  • 2664552 - Check Tool - Issue with FO/GO Object Invalid Effective End Date
  • 2472648 - Check Tool: How to check your SuccessFactors configuration

Keywords

PRB0043244, INC0032234, ECT-99520, SRSD-30140, Foundation Object, Pay Component Group, Pay Component, Manage Organization Pay and Job Structure, Pay, Component, Group, Code, ID, System, Error, paycomponentgroup, Create, New, Search, Advanced, Include, Inactives, check tool, This operation has led to unique key constraint violation, Import, basic salary, Is Migrated, InvalidEffectiveEndDate, Invalid Effective End Date check for FO/GO, EFFECTIVE_END_DATE, Foundation objects must have at least one open-ended record (end date Dec 31, 9999).. (InvalidEffectiveEndDate) , KBA , LOD-SF-EC-CMP-CAL , Calculated - Pay Comp Groups, Compa/ Range & Charts , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , Problem

Product

SAP SuccessFactors Employee Central all versions