The GPGENRPT.SQR - Create Generic Report Is Going To No Success
(Doc ID 2359853.1)
Last updated on FEBRUARY 05, 2019
Applies to:
PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and laterInformation in this document applies to any platform.
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.
Changes
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 |
Changes |
Cause |
Solution |
References |