GP - Some Employees Are Coming Up Twice On Employee Self Service Payslips (Doc ID 2134424.1)

Last updated on OCTOBER 26, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Some employees are coming up twice on Employee Self Service payslips.

There is one statement that is adding two view on component GP_SS_EE_PSLP.GBL.postBuild Event.
  
  The basis purpose of this statement is Load the Grid with payslips;
  
  &rows1 = &rs1.Select(Record.GP_SS_PSLP_1_VW, "where emplid = :1", %EmployeeId); /*Use to fetch all payslip file name with Regularity country */
  &rows2 = &rs1.Select(Record.GP_SS_PSLP_2_VW, "where emplid = :1", %EmployeeId); /*Use to fetch all payslip file name with Run type country */
  
  &rows = &rows1 + &rows2;
  
  Because Payslip file name is same for this employee and Run type country and Regularity country are different payslips are coming twice for this type of case.
  above code is not doing Intersection for this type of case ,It is doing Union all.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms