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

Last updated on JULY 27, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.

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

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