How To Fix HRPBSDEVAVG018 - More than one spouse record exists in IT 0021 for period &1 - &2

SAP Error Message - Details

• Message type: E = Error

• Message class: HRPBSDEVAVG - HR-VADM: Public Sector Pensions Act

• Message number: 018

• Message text: More than one spouse record exists in IT 0021 for period &1 - &2

What causes this issue?

For the spouse or life partner, there are records of infotype 0021
(Family/Related Person) with a different date of birth or with a
different birth name. The period for a marriage may only relate to a
marriage with one person.

System Response

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

How to fix this error?

Correct the period for the duration of the marriage or the data in
infotype 0021 (Family/Related Person).

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 HRPBSDEVAVG018 - More than one spouse record exists in IT 0021 for period &1 - &2 ?

  The SAP error message HRPBSDEVAVG018 indicates that there is more than one spouse record in the infotype 0021 (Family/Related Person) for a specific period. This situation can occur when an employee has multiple spouse records that overlap in the specified date range, which is not allowed in the system.
  Cause:
  
  Duplicate Records: The primary cause of this error is the existence of multiple spouse records (IT 0021) for the same employee that have overlapping validity periods.
  Data Entry Errors: It may arise from incorrect data entry, where a user inadvertently creates multiple spouse records for the same employee.
  System Migration Issues: If data was migrated from another system, it may have resulted in duplicate spouse records.
  
  Solution:
  To resolve this error, you need to ensure that there is only one valid spouse record for the specified period. Here are the steps to do this:
  
  
  Check Existing Records:
  
  Use transaction code PA20 (Display HR Master Data) or PA30 (Maintain HR Master Data) to view the spouse records for the employee in infotype 0021.
  Check the validity periods of the spouse records to identify any overlaps.
  
  
  
  Delete or Adjust Records:
  
  If you find duplicate records, you can either delete the unnecessary records or adjust the validity periods to ensure that only one spouse record is valid for the specified time frame.
  To delete a record, you can use transaction code PA30, select the record you want to delete, and then choose the delete option.
  
  
  
  Consult with HR:
  
  If you are unsure about which record to keep or delete, consult with the HR department or the employee to confirm the correct spouse information.
  
  
  
  Data Validation:
  
  After making changes, validate the data to ensure that the error message no longer appears when processing the employee's data.
  
  
  
  Related Information:
  
  Infotype 0021 (Family/Related Person): This infotype is used to maintain information about family members, including spouses. Each record must have a unique validity period.
  SAP HR Module: Understanding the HR module and how infotypes work is crucial for managing employee data effectively.
  Data Consistency: Maintaining data consistency in HR records is essential for accurate reporting and compliance with legal requirements.
  
  By following these steps, you should be able to resolve the HRPBSDEVAVG018 error and ensure that the employee's spouse information is correctly maintained in the system.