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).
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.
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.