How To Fix HRGB_GBSXP029 - No record exists for &1 and &2 in SxP Exclusion Reasons(Table T5G2F_DATE)

SAP Error Message - Details

• Message type: E = Error

• Message class: HRGB_GBSXP - Message for GBSXP

• Message number: 029

• Message text: No record exists for &1 and &2 in SxP Exclusion Reasons(Table T5G2F_DATE)

What causes this issue?

The processing of GBSXP has created an exclusion code that does not
exist in T5G2F_DATED. This should not be possible as all entries in
T5G2F_DATED are pre-configured by SAP and the code of GBSXP should only
use those entries.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

If the exclusion created as part of a "D"ay mark does not exist in SAP
standard then the processing of NCALE has been corrupted and this error
message is raised.

System Response

A permanent error has occurred during the processing of the payroll for
this employee. Payroll processing for the employee has been terminated.

How to fix this error?

Raise an OSS message stating that this error has occurred.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HRGB_GBSXP029 - No record exists for &1 and &2 in SxP Exclusion Reasons(Table T5G2F_DATE) ?

  The SAP error message HRGB_GBSXP029 indicates that there is no record found for the specified parameters in the SxP Exclusion Reasons table (T5G2F_DATE). This error typically occurs in the context of SAP HR (Human Resources) when dealing with employee data, particularly in relation to exclusion reasons for specific dates.
  Cause:
  
  Missing Data: The most common cause of this error is that there is no entry in the T5G2F_DATE table for the specified employee (or object) and the date range being queried.
  Incorrect Parameters: The parameters (&1 and &2) being passed to the query may be incorrect or not matching any existing records in the table.
  Configuration Issues: There may be issues with the configuration of the exclusion reasons or the related infotypes that are supposed to populate this table.
  Data Migration Issues: If data was recently migrated or imported, it’s possible that the relevant records were not included or were incorrectly formatted.
  
  Solution:
  
  Check the Table: Use transaction code SE16 or SE16N to check the contents of the T5G2F_DATE table. Verify if there are any records for the specified employee and date.
  Verify Parameters: Ensure that the parameters being used in the query are correct. Double-check the employee ID and the date range.
  Data Entry: If records are missing, you may need to enter the required exclusion reasons manually through the appropriate infotype (e.g., Infotype 5 for absence).
  Configuration Review: Review the configuration settings related to exclusion reasons in the SAP system. Ensure that all necessary settings are correctly configured.
  Consult Documentation: Refer to SAP documentation or help notes related to the specific infotype and exclusion reasons for further guidance.
  Check for Authorizations: Ensure that the user has the necessary authorizations to view or modify the records in the T5G2F_DATE table.
  
  Related Information:
  
  Infotype 5 (Absences): This infotype is often related to exclusion reasons and may need to be checked for the employee in question.
  SAP Notes: Look for relevant SAP Notes that might address this specific error or provide additional troubleshooting steps.
  Support: If the issue persists, consider reaching out to your SAP support team or consulting with an SAP HR expert for further assistance.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.