GP BR SQL Error ORA-00942: table or view does not exist, in Generating SEFIP Report
(Doc ID 1969063.1)
Last updated on APRIL 23, 2021
Applies to:
PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.1 to 9.1 [Release 9]Information in this document applies to any platform.
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
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 |