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

Last updated on FEBRUARY 06, 2019

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

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