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 - [CLI Driver][DB2/AIX64] SQL0150N" (Doc ID 2326706.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Symptoms

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 - [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 to reproduce the issue :
-------------------------------
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.

Changes

Cause

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