GP-BRA: Updates, Inserts and Deletes Statements in the GP_RTO_TRGR Table (Doc ID 1913428.1)

Last updated on JUNE 05, 2017

Applies to:

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

Symptoms

On : 9.1 version, Legislative

Even unchecked the Process Retro Triggers flag under calendar group, see the updates, inserts and deletes statements in the GP_RTO_TRGR table.
The calendars and calendar group are parametrized to not process retroactive.

It is not expected see these statements when process retro triggers is unchecked.

The issue can be reproduced at will with the following steps:

  1. Navigate to Main Menu > Global Payroll & Absence Mgmt > Absence and Payroll Processing > Define Calendars > Calendar Groups
  2. Uncheck the rocess Retro Triggers flag
  3. Calculate payroll under Main Menu > Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Absence and Payroll setting cobol sql trace
  4. See the results.

RC=0 COM Stmt=UPDATE PS_GP_RTO_TRGR SET TRGR_STATUS='I' ,CAL_RUN_ID=:1 WHERE TRGR_STATUS='U' AND EMPLID BETWEEN :2 AND :3 AND COUNTRY=:4 AND (('N'=:5) OR EMPLID IN (SELECT EMPLID FROM PS_GP_GRP_LIST_RUN WHERE RUN_CNTL_ID=:6 AND OPRID=:7) ) AND (('A'=:8) OR ('S'=:9 AND EMPLID IN (SELECT DISTINCT EMPLID FROM PS_GP_ITER_TRGR A WHERE A.CAL_RUN_ID=:10 AND A.ITER_TRGR_STATUS='U' AND A.EMPLID BETWEEN :11 AND :12) ) ) AND TRGR_EFFDT 17:30:20.570 6547 0.000 0.000 #1 RC=0 Bind-1, type=SQLPBUF, length=17, value=201212 CALC FOLHA

RC=0 COM Stmt=DELETE FROM PS_GP_RTO_TRGR WHERE CAL_RUN_ID=:1 AND EMPLID BETWEEN :2 AND :3 AND COUNTRY=:4 AND (('N'=:5) OR EMPLID IN (SELECT EMPLID FROM PS_GP_GRP_LIST_RUN WHERE RUN_CNTL_ID=:6 AND OPRID=:7) ) AND TRGR_STATUS='I' AND TRGR_CREATE_TS< (SELECT TRGR_CREATE_TS FROM PS_GP_RTO_TRG_WRK2 A WHERE A.EMPLID=PS_GP_RTO_TRGR.EMPLID AND A.COUNTRY=PS_GP_RTO_TRGR.COUNTRY AND A.TRGR_EVENT_ID=PS_GP_RTO_TRGR.TRGR_EVENT_ID AND A.TRGR_EFFDT=PS_GP_RTO_TRGR.TRGR_EFFDT AND A.CAL_RUN_ID=PS_GP_RTO_TRGR.CAL_RUN_ID)

RC=0 COM Stmt=INSERT INTO PS_GP_RTO_TRGR_WRK (EMPLID ,COUNTRY ,TRGR_EVENT_ID ,TRGR_EFFDT ,TRGR_CREATE_TS ,CAL_RUN_ID ) SELECT DISTINCT A.EMPLID ,C.COUNTRY ,A.TRGR_EVENT_ID ,A.TRGR_EFFDT ,A.TRGR_CREATE_TS ,A.CAL_RUN_ID FROM PS_GP_RTO_TRGR A ,PS_JOB B ,PS_GP_CAL_RUN_DTL C WHERE A.CAL_RUN_ID=:1 AND B.EMPLID BETWEEN :2 AND :3 AND B.EMPLID=A.EMPLID AND B.GP_PAYGROUP=C.GP_PAYGROUP AND (B.PAY_SYSTEM_FLG='GP' OR B.ABSENCE_SYSTEM_CD = 'AM') AND B.EMPL_STATUS IN ('A','P','Q','U') AND B.EFFSEQ= (SELECT MAX(B1.EFFSEQ) FROM PS_JOB B1 WHERE B1.EMPLID BETWEEN :4 AND :5 AND B1.EMPLID=B.EMPLID AND B1.EMPLID=A.EMPLID AND B1.EMPL_RCD=B.EMPL_RCD AND B1.EFFDT=B.EFFDT ) AND B.EFFDT 17:30:21.100 6621 0.000 0.000 #1 RC=0 Bind-1, type=SQLPBUF, length=17, value=201212 CALC FOLHA

The issue has the following business impact:
Due to this issue, users cannot understand the reason this is happening and need more details on it.

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