Technology Stack - EBS (MOSC)

MOSC Banner

R12.2.6 materialized views created in custom schema

edited Aug 4, 2017 5:03AM in Technology Stack - EBS (MOSC) 1 commentAnswered ✓

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            

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center