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
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.
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: 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' )
The issue can be reproduced at will with the following steps:
1. Apply FSCM 9.2 PUM 14
2. Run DDD audit report
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