HRMS 9.1 bundle #10 bug?
edited Jul 3, 2013 12:32PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓
I'm currently working on applying bundles 9-12 in our DEV environment.
I am receiving an error on bundle # 10 during the Run Create Views Script step.
The step ends in error.
Here are the last few lines from the log file.
SQL Successful - COMMIT
SQL Successful - IF EXISTS (SELECT 'X' FROM SYSOBJECTS WHERE TYPE = 'V' AND NAME = 'PS_HCDL_ADMIN_SRCH') DROP VIEW PS_HCDL_ADMIN_SRCH
SQL Successful - CREATE VIEW PS_HCDL_ADMIN_SRCH (EMPLID, EMPL_RCD, NAME, LAST_NAME_SRCH , PER_ORG) AS SELECT DISTINCT A.EMPLID , A.EMPL_RCD , B.NAME , B.LAST_NAME_SRCH , A.PER_ORG FROM PS_JOB A , PS_PERSON_NAME B WHERE A.HR_STATUS = 'A' AND A.EMPLID = B.EMPLID AND A.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT <= { FN CURDATE() }) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = A.EFFDT)
0