My Oracle Support Banner

GPESP: When Generating the CRA File After Correction Payroll the Amount in PS_GPES_SS_CRA_RPT is Doubled (Doc ID 3027697.1)

Last updated on JUNE 07, 2024

Applies to:

PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The CRA engine does not consider payroll versions.

There is a monthly and a corrective calendar group, only the maximum version (the CORRECTION calendar group) should be printed.

Instead, it is printing the sum of both versions (the MONTHLY and the CORRECTION calendar groups).

Steps to reproduce the issue:
1. Choose any employee on a monthly calendar group that shows the earning “SALARIO BASE”.

2. Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Payroll: Finalize January 2021.

3. Workforce Administration > Job Information > Job Data: update SALBSE rate code on Job Data to a lower value e.g. from 1500 to 1400.

4. Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Payroll.
    Calculate the monthly calendar group for next month. In this example, February 2022 is the next month.

5. Global Payroll & Absence Mgmt, Social Security/Insurance > Create CRA File ESP.
    Run CRA file for February.

6. Run the following SQL

    Notice: As the salary for the previous month was decreased, the CRA table (PS_GPES_SS_CRA_RPT) will show the modification on CRA code 0001.
               The field “GPES_SS_CRA_ACTION” will be filled with “M” meaning that there is a retro Modification.

7. Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Payroll:
    Finalize February 2021

8. Setup HCM > Product Related > Global Payroll & Absence Mgmt > Framework > Calendars > Calendars
    Create a new calendar group for the same month and the same employee.
    Set the run type of this new calendar group as “CORRECCION”.

9. Global Payroll & Absence Mgmt > Absence and Payroll Processing > Prepare Payroll > Review Triggers > Retro
    Add a retro trigger and run the "CORRECCION" calendar group.

10. Nothing changes on the payroll but when the CRA file is run again, the amount has doubled:
      Global Payroll & Absence Mgmt, Social Security/Insurance > Create CRA File ESP:
      Run CRA file for February again.

The CRA engine does not consider payroll versions. In this example, only the maximum version (the CORRECCION calendar group) should be printed.
Instead, it is printing the sum of both versions (the MONTHLY and the CORRECION calendar groups).

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.