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
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;