FRM-40200 Field is Protected against Update

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

 

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.

 

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

 

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.

 

Hi "m.hari"

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

Simple