Delivered SQR Reports Failing For HCM 9.2 PUM 22 On MS SQL Database

(Doc ID 2326069.1)

Last updated on MAY 02, 2018

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

STATEMENT
-----------------
Delivered SQR Create/Print Payslips AUS report failing for HCM 9.2 PUM 22 on MS SQL database

STEPS TO REPLICATE
-------------------------------
1, Login as admin

2, Navigate to : Main Menu> Global Payroll & Absence Mgmt > Payslips > Create/Print Payslips AUS and locate the below error:

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

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

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

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


Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms