R12.2.6 materialized views created in custom schema
Dear Experts,
EBS:12.2.6
DB: 12.1.0.2
Trying to create a materialized view in R12.2.6. Following note 1577661.1
Please see the error:
Create logical view:
CREATE OR REPLACE VIEW "ZZCWH"."ZZCWH_DBT_ADJUST_NAMES_01_A#" ("INSTANCE_CODE", "ORGANIZATION_CODE", "ADJUSTMENT_ITEM1", "ADJUSTMENT_ITEM2", "ADJUSTMENT_ITEM3", "ADJUSTMENT_ITEM4", "ADJUSTMENT_ITEM5", "ADJUSTMENT_ITEM6", "ADJUSTMENT_ITEM7", "ADJUSTMENT_ITEM8", "ADJUSTMENT_ITEM9", "ADJUSTMENT_ITEM10", "VOLUME_VARIANCES_NAME", "INVENTORY_ESTIMATION_NAME")
AS SELECT 'dvvgr01'AS INSTANCE_CODE
,mp.ORGANIZATION_CODE
,an.ADJUSTMENT_ITEM1
,an.ADJUSTMENT_ITEM2
,an.ADJUSTMENT_ITEM3
,an.ADJUSTMENT_ITEM4
,an.ADJUSTMENT_ITEM5
,an.ADJUSTMENT_ITEM6
,an.ADJUSTMENT_ITEM7
,an.ADJUSTMENT_ITEM8
,an.ADJUSTMENT_ITEM9
,an.ADJUSTMENT_ITEM10