E-AD :Unable To Create Materialized View In Application Designer On PT 8.55.14 in MSSQL
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.
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
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