In DB2 environment,When user clicks "Apply Screening"Button, it generates SQL Error-"(3) File: /vob/peopletools/src/psppr/ramget.cppSQL error. Stmt #: 704 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0150N"

(Doc ID 2326706.1)

Last updated on NOVEMBER 09, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Manage Job Openings


Apply Screening Results produces SQL Error online.


 

ERROR
-----------------------
SQL Error:
(3) File: /vob/peopletools/src/psppr/ramget.cppSQL error. Stmt #: 704 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0150N
The target fullselect, view, typed table, materialized query table, range-clustered table,
or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation i
Failed SQL stmt: SELECT HRS_PERSON_ID, HRS_RCMNT_ID, HRS_JOB_OPENING_ID, HRS_SCREENING_ID, JOBCODE, HRS_SCR_GEN_SCORE, REQ_SCR_EDEX_SCORE,
REQ_SCR_COMP_SCORE, REQ_SCR_ACMP_SCORE, REQ_SCR_KEY_SCORE, REQ_SCR_QUES_SCORE, HRS_SCR_GEN_COUNT, REQ_SCR_EDEX_COUNT, REQ_SCR_COMP_COUNT,
REQ_SCR_ACMP_COUNT, REQ_SCR_KEY_COUNT, REQ_SCR_QUES_COUNT, HRS_SCR_STATUS, HRS_SCR_STS_RSN, STATUS_CODE, STATUS_REASON, HRS_STATUS_DT,
GVT_APPL_AP_SCORE, GVT_APPL_VP_SCORE, HRS_APP_SEL_SCORE, HRS_SCR_SCORE, HRS_SCR_TTL_SCORE, HRS_RSLT_APPLIED, NAME_DISPLAY, APP_PER_STATUS,
HRS_ROW_ADD_DTTM, HRS_ROW_ADD_OPRID, HRS_ROW_UPD_DTTM, HRS_ROW_UPD_OPRID
FROM PS_HRS_RCM_SCR2_VW
WHERE HRS_PERSON_ID=:1 AND HRS_RCMNT_ID=:2 AND HRS_JOB_OPENING_ID=:3
AND HRS_SCREENING_ID=:4 AND JOBCODE=:5 FOR
UPDATE OF HRS_RSLT_APPLIED, HRS_ROW_UPD_DTTM




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation and Actions: Home > Recruiting > Search Job Openings > Manage Job Opening > Applicant Screening Tab > Run Preliminary > Screening Results > Click Apply Results button > Click OK button on Message Pop Up.
2. Error pops up.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot do screening of applicants.

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