ETL9.2: Unable To Create Materialized Views for SQL server (Doc ID 2282987.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

PeopleTools 8.55: The customer is  unable to create below materialized views

Customer is  unable to create below materialized views
ACA_MONTHLY_JOB
ACA_MONTHLY_TL
ACA_WEEKLY_JOB
ACA_WEEKLY_TL
TL_CALPYESEL_VW

build script shows only drop view ... but not generating create view, example below.

USE FSUHRDEM
go
SET IMPLICIT_TRANSACTIONS ON
go
IF EXISTS (SELECT 'X' FROM SYSOBJECTS WHERE TYPE = 'V' AND NAME =
'PS_ACA_WEEKLY_JOB') DROP VIEW PS_ACA_WEEKLY_JOB

Solution

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