PeopleSoft - Career Site - Job Opening is Displayed in Careers Page Even When Remove Date = Current Date

Applies To:

PeopleSoft 9.1
Career Sites
Jobs

Symptoms:

Due to this issue, the Job opening still appears in external careers site one day longer than expected. In other words, Job Opening is displayed in Careers page even if the remove date equals the current date.

The expected behaviour is that the job is removed when the current date equals the remove date.

Steps to Reproduce:

1. In PeopleSoft navigate to Recruiting > Create Job Opening.

2. Create a Job Opening with Job Posting remove date as Tomorrow's date and Post Date as Today's date

3. The Posting Duration(Days) shows as 1 day.

4. The Job Opening appears on external careers page on both today and tomorrow, whereas it should only appear for today as the Posting duration is only for 1 day (even after running the Build Job Index process).

 

Cause

This is an Oracle Bug (#14021731). The below SQL views have an issue with the WHERE Clause.

The WHERE Clause in these views is date inclusive causing the problem.

HRS_JO_POST_I View

HRS_JO_PSTBTH_I View

HRS_JO_PSTEXT_I View

HRS_JO_PSTINT_I View

HRS_JO_ROWEXT_I View

HRS_JO_ROWINT_I View

HRS_JO_SITEXT_I View

HRS_JO_SITINT_I View

 

Solution

In the above listed views, changed the WHERE Clause from "HRS_JO_PST_CLS_DT >= %CurrentDateIn" to "HRS_JO_PST_CLS_DT > %CurrentDateIn"

Note the >= change to =, that is the key change. We want the WHERE Clause to exclude the current date.

See Oracle Support Doc ID 1488302.1 for more information.

Feedback and Knowledge Base