Double WHERE clause SQL In Application Package HR_DIRECT_REPORTS.DirectReportsTablesServices

(Doc ID 2320625.1)

Last updated on DECEMBER 14, 2017

Applies to:

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

Symptoms

SQL issue in Application Package HR_DIRECT_REPORTS.DirectReportsTablesServices

In method UpdateStatusEffDt there are 2 SQL delete statments that have a double where clause.

Application Package HR_DIRECT_REPORTS.DirectReportsTablesServices.OnExecute

The following 2 SQLExec statments have a "WHERE WHERE" clause. This is incorrect.

SQLExec("DELETE FROM " | &recname | " WHERE WHERE EMPLID = :1 AND EMPL_RCD = :2", &recCurJob.EMPLID.Value, &recCurJob.EMPL_RCD.Value);
SQLExec("DELETE FROM " | &recname | " WHERE WHERE SUPERVISOR_ID = :1 AND SUPERVIS_EMPL_RCD = :2", &recCurJob.EMPLID.Value, &recCurJob.EMPL_RCD.Value);

These are on lines 1069 and 1070

STEPS
-----------------------

  1. Log into Application Designer
  2. Open Application Package HR_DIRECT_REPORTS.DirectReportsTablesServices.OnExecute

Changes

 

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