Generate Individual Development Plan report causes SQL error

(Doc ID 2397901.1)

Last updated on MAY 15, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Employee/Organization Development

When attempting to generate the report of Individual Development Plan, the following error occurs.

ERROR
-----------------------
SQL error. Function: SQLExec
Error Position: 0
Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SYSDATE'.
Statement: SELECT C.DESCR FROM PS_EMPLOYEE_REVIEW A, PS_REVW_SCALE_TBL B, PS_REVW_RATING_TBL C WHERE A.EMPL_RCD = 0 AND A.RATING_SCALE = B.RATING_SCALE AND C.REVIEW_RATING = :1 AND C.RATING_MODEL = :2 AND C.EFFDT = (SELECT MAX(C1.EFFDT) FROM PS_REVW_RATING_TBL C1 WHERE C1.RATING_MODEL = C.RATING_MODEL AND C1.REVIEW_RATING = C.REVIEW_RATING AND C1.EFFDT<= SYSDATE) AND B.EFFDT = (SELECT MAX(B1.EFFDT) FROM PS_REVW_SCALE_TBL B1 WHERE B.RATING_SCALE = B1.RATING_SCALE AND B1.EFFDT <= SYSDATE)
Original Statement: SELECT C.DESCR FROM PS_EMPLOYEE_REVIEW A, PS_REVW_SCALE_TBL B, PS_REVW_RATING_TBL C WHERE A.EMPL_RCD = 0 AND A.RATING_SCALE = B.RATING_SCALE AND C.REVIEW_RATING = :1 AND C.RATING_MODEL = :2 AND C.EFFDT = (SELECT MAX(C1.EFFDT) FROM PS_REVW_RATING_TBL C1 WHERE C1.RATING_MODEL = C.RATING_MODEL AND C1.REVIEW_RATING = C.REVIEW_RATING AND C1.EFFDT<= SYSDATE) AND B.EFFDT = (SELECT MAX(B1.EFFDT) FROM PS_REVW_SCALE_TBL B1 WHERE B.RATING_SCALE = B1.RATING_SCALE AND B1.EFFDT <= SYSDATE)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu >> Workforce Development >> Career Planning >> Reports >> Individual Development Plan
2. select an employee for the report.
3. click on Generate Plan button.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate the report of Individual Development Plan for an employee

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