My Oracle Support Banner

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

Last updated on NOVEMBER 26, 2021

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

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
Goal
Solution
References


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