PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center