My Oracle Support Banner

E-INST: Create View Errors during Classical Install of Campus Solution Upgrade Source Image (Doc ID 2450953.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, Campus Solution Upgrade Source Image 8, Linux 7, Oracle 12.2.01

When attempting to install Campus Solution 9.2 Upgrade Source Image 8 manually on Linux 7 by following the Oracle document - "https://docs.oracle.com/cd/E88924_01/psft/pdf/PeopleSoft9.2_Application_Installation_for_Oracle_PeopleSoft_PeopleTools8.56_July2018.pdf" Chapter 6C
following  error occurs during create views step.


ERROR
-----------------------

 
 CREATE VIEW PS_SSR_ADC_IACVWLN (SSR_AC_CONTX_TYPE, SSR_AC_CONTENT_TP, LANGUAGE_CD, DESCR) AS SELECT A.SSR_AC_CONTX_TYPE , A.SSR_AC_CONTENT_TP , LN.LANGUAGE_CD , LN.DESCR FROM PS_SSR_AC_ITEMTYPE A , PS_SSR_AC_ITYPELNG LN WHERE A.SSR_IAM_ACTYACTN = 'Y' AND LN.SSR_AC_CONTX_TYPE = A.SSR_AC_CONTX_TYPE AND LN.SSR_AC_CONTENT_TP = A.SSR_AC_CONTENT_TP
Error: Unable to process create statement for SSR_ADC_IACVWLN
 SQL Error. Error Position: 272 Return: 942 - ORA-00942: table or view does not exist
 
 CREATE VIEW PS_ACADCALTRMVW3LN (INSTITUTION, ACAD_CAREER_TS_HDR, ACAD_CAL_ID_TS_HDR, STRM, LANGUAGE_CD, DESCRSHORT, DESCR) AS SELECT A.INSTITUTION ,A.ACAD_CAREER ,A.ACAD_CALENDAR_ID ,A.STRM ,C.LANGUAGE_CD ,C.DESCRSHORT ,C.DESCR FROM PS_ACAD_CALTRM_TBL A , PS_TERM_TBL B , PS_TERM_TBL_LANG C WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM AND B.INSTITUTION = C.INSTITUTION AND B.ACAD_CAREER = C.ACAD_CAREER AND B.STRM = C.STRM AND B.TERM_END_DT >= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')
Error: Unable to process create statement for ACADCALTRMVW3LN

Creating View ACAD_CLTRMV4_LN
 - SQL Error. Error Position: 255 Return: 942 - ORA-00942: table or view does not exist
 
 CREATE VIEW PS_ACAD_CLTRMV4_LN (INSTITUTION, ACAD_CAREER, ACAD_CAL_ID_TS_HDR, STRM, LANGUAGE_CD, DESCRSHORT, DESCR) AS SELECT A.INSTITUTION , A.ACAD_CAREER , A.ACAD_CALENDAR_ID , A.STRM , B.LANGUAGE_CD , B.DESCRSHORT , B.DESCR FROM PS_ACAD_CALTRM_TBL A , PS_TERM_TBL_LANG B WHERE B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.STRM = A.STRM
Error: Unable to process create statement for ACAD_CLTRMV4_LN


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download and install CS 9.2 image 8
2. Follow the Peopletools 8.56  Database creation steps manually using Peopletools 8.56 installation Guide
3.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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