My Oracle Support Banner

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.


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


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




To view full details, 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 a vibrant support community of peers and Oracle experts.