title: How to avoid 'unique constraint' error message when creating a view
body: <p>I have a normal View and iam getting the error message : </p>
  
  <pre><code>[Error] Execution (6: 83): ORA-00604: error occurred at recursive SQL level 1
  ORA-00001: unique constraint (SYS.I_COL1) violated
  </code></pre>
  
  <p>But I don't get what I am doing wrong. It says the <code>bacl.Description</code>, <code>batl.Description</code>, <code>bagl.description</code> are violating the uniqueness constraint.</p>
  
  <pre><code>    CREATE OR REPLACE FORCE VIEW CCI.VW_TA04_BAC_PAGE_4_2 as
     SELECT 
            bac.id, 
           bac.code code, 
           bacl.DESCRIPTION, 
           bac.order_key, 
          bac.bat_id,  
          batl.description,  
          bac.bag_id,  
          bagl.description,  
          bac.weight_factor,  
          bac.display
       FROM BART_CATEGORIES bac,
            BART_CATEGORIES_LAE bacl,
            BART_CATEGORY_GROUPS bag,
            BART_CATEGORY_GROUPS_LAE bagl,
            BART_CATEGORY_TYPES bat,
            BART_CATEGORY_TYPES_LAE batl
      WHERE bacl.lae_id = pkg_process.language
      AND batl.lae_id = pkg_process.language
      AND bagl.lae_id = pkg_process.language
  
      AND (bac.bag_id = bag.id)
      AND (bac.bat_id = bat.id)     
  
      AND (bacl.BAC_ID = bac.id)
      AND (bagl.BAG_ID = bag.id)
      AND (batl.BAT_ID = bat.id)
  </code></pre>
  
  <p>Thanks for any advice.</p>