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