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

 

required set yes
not work why?

 

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;