GP BR SQL Error ORA-00942: table or view does not exist, in Generating SEFIP Report (Doc ID 1969063.1)

Last updated on MAY 11, 2018

Applies to:

Symptoms

 Error in generating SEFIP

When is processed  the SEFIP Report in the dmo base occurs the SQL error below:

SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 18:
  ORA-00942: table or view does not exist
SQL: SELECT NID_PIS_BRA, HIRE_DT, REHIRE_DT, SEFIP_CATEGORY_BRA, CBO_CD_BRA,
  EMPLID, EMPL_RCD, EFFDT, ACTION FROM PS_GPBR_SEFIP_EMPG WHERE
  PROCESS_INSTANCE = :1 AND ESTABID = :2 ORDER BY NID_PIS_BRA, HIRE_DT,
  REHIRE_DT, SEFIP_CATEGORY_BRA, EMPLID, EMPL_RCD, EFFDT, EFFSEQ

Error on line 1266:
  (SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OCIStmtExecute error 904 in cursor 39:
  ORA-00904: "WD2"."SEG_BGN_DT": invalid identifier
SQL: SELECT DISTINCT JOB3.EMPLID, JOB3.EFFDT, JOB3.EMPL_RCD, JOB3.EMPL_STATUS,
  JOB3.ACTION, WD2.CBO_CD_BRA, WD2.SEFIP_CATEGORY_BRA, WD2.SEG_END_DT,
  WD2.SEG_BGN_DT FROM PS_GPBR_SEFIP_WA WD2 , PS_JOB JOB3 ,
  PS_GP_RSLT_SEG_VW RS0

Error on line 3128:
  (SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 91:
  ORA-00942: table or view does not exist
SQL: SELECT PSA.NEWVALUE FROM PS_GPBR_SEFIP_AUDT PSA WHERE
  PSA.PROCESS_INSTANCE = :1 AND PSA.KEY1 = :2 AND PSA.RECNAME =
  'PERSON' AND PSA.FIELDNAME = 'BIRTHDATE' AND PSA.AUDIT_ACTN = 'C' AND
  PSA.AUDIT_STAMP = (SELECT MAX(AUDIT_STAMP) FROM PS_GPBR_SEFIP_AUDT WHERE
  KEY1 = PSA.KEY1 AND RECNAME = PSA.RECNAME AND FIELDNAME =
  PSA.FIELDNAME AND AUDIT_ACTN = PSA.AUDIT_ACTN AND AUDIT_STAMP >= :3 AND
  AUDIT_STAMP
Error on line 7158:
  (SQR 3716) Error in SQL statement.


Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.

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

1. Global Payroll & Absence Mgmt > Social Security / Insurance > SEFIP Report BRA
2. Fill the fields
3. Notice the issue mentioned above.

Due to this issue, users cannot generate the SEFIP Report BRA

Cause