GP UK - Cannot Update Court Orders For Future Dated Rehire
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.
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);
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms