My Oracle Support Banner

Materialized View APPS.CSP_SUP_DEM_PN_MV Invalid After Applying CSP Patch 21873142 (Doc ID 2164685.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Materialized view APPS.CSP_SUP_DEM_PN_MV becomes INVALID after applying Spares Management (CSP) Patch 21873142:R12.CSP.B - LIGHTWEIGHT MLS ISSUES FOR LOCAL LANGUAGE JAPANESE IN SPARES MANAGEMENT MODULE.

It appears that one of the base tables for the materialized view had a column definition changed.
Table CSP.CSP_PLANNING_PARAMETERS had column NODE_NAME change from VARCHAR2(50) to VARCHAR2(240).

What steps should we take to get materialized view APPS.CSP_SUP_DEM_PN_MV Valid again?
 

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.