E-AD :Unable To Create Materialized View In Application Designer On PT 8.55.14 in MSSQL (Doc ID 2284417.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

On : 8.55 version, Application Designer


After upgrading to 8.55.14 client cannot create materialized view in the AD of this PT version. The SQL script created by AD only has the drop view statement but doesn't have create view statement.

client was testing with the delivered PS_CALPYESEL_VW view

EXPECTED BEHAVIOR
-----------------------
the build should drop the view and recreate it as expected

STEPS
-----------------------
The issue can be reproduced at will with the following steps: in a tools 8.55.14 environment with MSSQL


1.  open a materialized view
2. under build select t create view and make sure drop view if it is already created is selected and build the SQL

Result: the Drop command is present in the SQL script but there is no build SQL


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