My Oracle Support Banner

E-SQR: GPBRRC01.SQR is Failing with Error "(SQR 5528) ORACLE OCIStmtExecute error 904 in cursor 24: ORA-00904: "TN"."GPBR_RELEASE_WORK": invalid identifier" (Doc ID 2656706.1)

Last updated on JULY 28, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the delivered SQR Report GPBRRC01, the following error occurs:


"(SQR 5528) ORACLE OCIStmtExecute error 904 in cursor 24:
  ORA-00904: "TN"."GPBR_RELEASE_WORK": invalid identifier
SQL: SELECT TN.GPBR_TERM_NOTIF, TN.GPBR_HOM_NEW_JOB, TN.GPBR_HOM_NOTIF_ER,
  TN.GPBR_RELEASE_WORK FROM PS_GPBR_PAYEE_PARM TN WHERE TN.EMPLID = :1
  and TN.EMPL_RCD=:2

Error on line 768:
  (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. Login to PIA
2. Navigate to Global Payroll & Absence Mgmt
3. Then select Termination Processing
4. Then select GRFC Report BRA
5. Then select GRFC 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


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