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:
    16
    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:
    403
    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,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Please have a look into the below thread.

    Explanation