GP UK - Cannot Update Court Orders For Future Dated Rehire (Doc ID 2165646.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Symptoms

Users are unable to update court orders for a future dated rehire.
The problem seems to be with the pre-build component peoplecode and in particular the following SQLExec, which uses a check based on current date and then if no rows are returned the user cannot make any updates on the page.

  SQLExec("select a.hr_status from ps_job a where a.emplid=:1 and a.empl_rcd=:2 and a.effdt=(select max(b.effdt) from ps_job b where b.emplid=a.emplid and b.empl_rcd=a.empl_rcd and b.effdt<=%CURRENTDATEIN) and a.effseq=(select max(b.effseq) from ps_job b where b.emplid=a.emplid and b.empl_rcd=a.empl_rcd and b.effdt=a.effdt)", &RS3(&i).PERS_SRCH_GBL.EMPLID.Value, &RS3(&i).PERS_SRCH_GBL.EMPL_RCD.Value, &active_emp_status);

Cause

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