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

HRPBSDEVAVG018 - Overview

• 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