My Oracle Support Banner

EAP: DDDAUDIT Shows Materialized View (MQT) APOP_VENDOR_LVW as Missing but will not Build on DB2 (Doc ID 2540963.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
---------------------
FSCM 9.2 Image 29
PeopleTools 8.56.12
DB2 Database

When attempting to create MQT view APOP_VENDOR_LVW, the following error occurs.

ERROR
-----------------------
SQL0204N "OWNER.TBSPACENM" is an undefined name. SQLSTATE=42704


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply image and PeopleTools upgrade
2. Run DDAUDIT - shows (MQT-1) Materialized Query Table defined in the Application Designer and not found in the Database:

Record Name Ownerid
--------------- -------
APOP_VENDOR_LVW FAP

3. Attempt to build following in App Designer

CREATE TABLE OWNER.PS_APOP_VENDOR_LVW (SETID, VENDOR_ID,
AP_PERIOD_NAME, AP_ACTION_SUPPLIER, LANGUAGE_CD, VENDOR_NAME_SHORT,
VNDR_NAME_SHRT_USR) AS (SELECT A.SETID , A.VENDOR_ID ,
A.AP_PERIOD_NAME , A.AP_ACTION_SUPPLIER , VL.LANGUAGE_CD ,
VL.VENDOR_NAME_SHORT , VL.VNDR_NAME_SHRT_USR FROM PS_APOP_VENDOR_MV A
, PS_VENDOR_LANG VL WHERE VL.SETID = A.SETID AND VL.VENDOR_ID =
A.VENDOR_ID) DATA INITIALLY DEFERRED REFRESH DEFERRED MAINTAINED BY
USER DISABLE QUERY OPTIMIZATION IN OWNER.TBSPACENM


Changes

 

Cause

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
Symptoms
Changes
Cause
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.