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!

FRM-40200 Field is Protected against Update

Discussion in 'Oracle Apps Technical' started by m.hari, Jun 14, 2011.

  1. m.hari

    m.hari Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I am new to Apps, and I am trying to register a table in APPS, while entering fields its throwing an error

    FRM-40200 Field is Protected against Update

    Plese help me in this...PFA

    Thanks in Adavnce
     
  2. karthikeyang84

    karthikeyang84 Active Member

    Messages:
    18
    Likes Received:
    6
    Trophy Points:
    110
    Location:
    Hosur
    Hi Hari,

    In Attachment - You queering the CMC_EMP Table.

    If you add the attachment, first query then make the attachment.

    Give the exact area where ur getting error.
     
  3. m.hari

    m.hari Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Thanks for your reply...Sorry that I have attached another file....The problem is I have created a table in database, created public synonym for it in apps schema

    Then I am trying to register the table in Apps and when I am placing my cursor in TableName text area, it is showing error

    FRM-40200 Field is Protected against Update
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    432
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Table must be registered using ad_dd.register_table package from back end.
    columns with using add_dd.register_column. for syntax and parameters any way we have guru (google) :) best of luck
    then go to oracle apps and query it.
     
    m.hari likes this.
  5. Hamza Bukhari

    Hamza Bukhari Active Member

    Messages:
    25
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Pakistan
    Hi "m.hari"

    For Your "FRM-40200" Problem the Solution is,
    Set the "Update Property" of Both "the object" & "data block" to "TRUE"

    Simple :rolleyes:
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Please have a look into the below thread.

    Explanation
     
  7. MD. SAIFUL ISLAM

    MD. SAIFUL ISLAM Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    DHAKA
    required set yes
    not work why?
     
  8. kiran.marla

    kiran.marla Forum Genius

    Messages:
    432
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    For registering table .. use the following script. Enter table name and application module names. let me know if you have any queries.

    ------------------register table and columns script---------------
    DECLARE
    p_table_name VARCHAR2(100) :=:table_name;
    p_app_mod VARCHAR2(100) :=:application_module;
    CURSOR c1 IS
    SELECT
    column_id,
    table_name,
    column_name,
    data_type,
    data_length,
    nullable,
    data_precision,
    data_scale
    FROM
    all_tab_columns
    WHERE
    table_name = p_table_name
    ORDER BY column_id;

    BEGIN
    ad_dd.register_table(
    p_appl_short_name => p_app_mod, --Application name in which you want to register
    p_tab_name => p_table_name,--Table Name
    p_tab_type => 'T', -- T for Transaction data ,S for seeded data
    p_next_extent => 512, -- default 512
    p_pct_free => 10, -- Default 10
    p_pct_used => 70 --Default 70
    );

    FOR rec IN c1 LOOP
    ad_dd.register_column(
    p_appl_short_name => p_app_mod,--Application Name
    p_tab_name => p_table_name,--Table Name
    p_col_name => rec.column_name,--Column Name
    p_col_seq => rec.column_id,--Column Sequence
    p_col_type => rec.data_type,--Column Data type
    p_col_width => rec.data_length,--Column Width
    p_nullable => rec.nullable,--Use'N' if mandatory column otherwise 'Y'
    p_translate => 'N',--Use 'Y' if this has translatable values
    p_precision => rec.data_precision,--Decimal precision
    p_scale => rec.data_scale --Number of digits in number
    );
    END LOOP;

    COMMIT;
    END;