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.
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?
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