Create All Views Step Failed In Upgrade From Financials 9.1 To Financials 9.2 PUM Image 5 for Views PS_RTBL_CFDEPLY_VW and PS_RTBL_CF_VW (Doc ID 1935427.1)

Last updated on APRIL 08, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
-----------------------
Upgrading from Financials 9.1 to Financials 9.2 PUM5
Development database
RTBL is not installed

When attempting to run CREATEVW.DMS from Task 5-15-6: Creating All Views, the following error occurs.

ERROR
-----------------------
Creating View  RTBL_CFDEPLY_VW
- SQL Error. Error Position: 70  Return: 928 - ORA-00928: missing SELECT keyword

CREATE VIEW PS_RTBL_CFDEPLY_VW (FIELDNAME, SETID, CF_VALUE, EFFDT) AS  UNION SELECT 'PROJECT_ID',A.SET_OVERRIDE,A.PROJECT_ID ,NULL FROM PS_PROJECT A, PS_PROJECT_RTBL B WHERE A.EFF_STATUS = 'A' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID  AND B.RTBL_DATA <> ' '
Error: Unable to process create statement for RTBL_CFDEPLY_VW
----
Creating View  RTBL_CF_VW
- SQL Error. Error Position: 106  Return: 942 - ORA-00942: table or view does not exist

CREATE VIEW PS_RTBL_CF_VW (FIELDNAME, SETID, CF_VALUE) AS SELECT DISTINCT FIELDNAME ,SETID ,CF_VALUE FROM PS_RTBL_CFDEPLY_VW MINUS ( SELECT A.FIELDNAME ,A.SETID ,A.CF_VALUE FROM PS_RTBL_DEP_CF_HIS A , PS_RTBL_DEP_CF B WHERE A.CF_DEPLOY_REQ_ID=B.CF_DEPLOY_REQ_ID AND B.STATUS_CF_DEPLOY='P')
Error: Unable to process create statement for RTBL_CF_VW



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run CREATEVW.DMS



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