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
- Go to Admin tool- Check tool
- Select EC Core-Run
- Result: Invalid Effective End Date check for FO/GO
Second troubleshoot
- Admin Center
- Manage Organization, Pay and Job Structure
- Pay Component Group
- Result: Base Salary cannot be found (not even as inactive)
Third troubleshoot
- Import Foundation Data
- Pay Component Group
- Import the respective Pay Component Group correcting the effective end date.
- Result:System returns a message that the pay component group does not exist
- Monitor job result: This operation has led to unique key constraint violation
Fourth Troubleshoot
- Manage Organization, Pay and Job Structure.
- Create new
- Pay component group
- Pay Component Group ID = Base Salary
- 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:
- Create a case for: LOD-SF-EC-FOO
- 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
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