My Oracle Support Banner

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 22, 2020

Applies to:

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


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

the build should drop the view and recreate it as expected

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


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

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