1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

HELP !!! 6 warnings when deploying one of my mappings... (ORA-06550 & ORA-00904)

Discussion in 'Oracle Forms and Reports' started by rezkhafn4u, Nov 14, 2010.

  1. rezkhafn4u

    rezkhafn4u Guest

    Hi to All
    I have a Problem when I want to Deploy One of My Mapping with Oracle warehouse builder 11g
    I test it in Design Center and Control Center...
    It gave me a these warnings and I want to Know how to solve it
    plz help me

    --------------------------------------------------------------------------------
    this is the warning in my jobs:

    ACME_POS_LOCATION1 Create Success

    STAGE_MAP Create Warning

    ORA-06550: line 11, column 3: PL/SQL: SQL Statement ignored

    STAGE_MAP Create Warning

    ORA-06550: line 128, column 39: PL/SQL: ORA-00904: "REGIONS"."REGION_KEY": invalid identifier

    STAGE_MAP Create Warning

    ORA-06550: line 277, column 7: PL/SQL: SQL Statement ignored

    STAGE_MAP Create Warning

    ORA-06550: line 349, column 39: PL/SQL: ORA-00904: "REGIONS"."REGION_KEY": invalid identifier

    STAGE_MAP Create Warning

    ORA-06550: line 62, column 39: PL/SQL: ORA-00904: "REGIONS"."REGION_KEY": invalid identifier

    STAGE_MAP Create Warning

    ORA-06550: line 77, column 3: PL/SQL: SQL Statement ignored



    Job Summary
    Updated : 2010-11-11 14:33:02.0 Job Final Status : Completed with warnings Job Processed Count : 2 Job Error Count : 0 Job Warning Count : 6


    --------------------------------------------------------------------------------

    all of my tables and other mappings Deployed successfully Except this one and with these warnings and I couldn't Execute it :(

    Thanks for your help