The GPGENRPT.SQR - Create Generic Report Is Going To No Success (Doc ID 2359853.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

The GPGENRPT.SQR - Create Generic Report is going to no success

STEPS TO REPLICATE
---------------------
1, Login as admin, navigate to Main Menu>Global Payroll and Absence Mgnt>Absence and Payroll Processing> Reports>Create Generic Report

and locate the below error:

(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 207 in cursor 30:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'pin_num'.
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 11501 in cursor 30:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]The batch could not be analyzed because of compile errors.

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

(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 207 in cursor 31:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'pin_num'.
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 11501 in cursor 31:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]The batch could not be analyzed because of compile errors.

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


Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.

Cause

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