EGL9.2: While Upgrading to 9.2.014 Encountered "(VIEWS-1) Views defined in the Application Designer and not found in the Database:" EOEN_SERVER_EVT (Doc ID 2081550.1)

Last updated on NOVEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-----
After Applying image #14 Customers who are on PeopleTools 8.53 noticed a view 'EOEN_SERVER_EVT' that has come with the image is having an issue. There are couple of tables -PSPTSVREVENTDEF & PSPTPNCOLLEVTS being referenced by the view, which do not exist.

Error
-----------------------

Error: EOEN_SERVER_EVT - SQL Error. Error Position: 92 Return: 942 - ORA-00942: table or view does not exist

CREATE VIEW PS_EOEN_SERVER_EVT (EVENT_NAME) AS SELECT A.EVENT_NAME FROM PSPTSVREVENTDEF A , PSPTPNCOLLEVTS B WHERE A.EVENT_NAME = B.EVENT_NAME AND B.PTPNCOLLNAME='PUSHNOTIFICATIONWINDOW' AND A.PTSVREVENTDATASTR =( SELECT C.PTSVREVENTDATASTR FROM PSPTSVREVENTDEF C WHERE C.EVENT_NAME='SENDNOTE' )

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply FSCM 9.2 PUM 14
2. Run DDD audit report

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