"Modify Once" field property

[Former Member]

Hi All,

I set "Modify Once" property for one field of my repository table in MDM Console, but i can modify it after

initial upload from import manager or after creation in MDM Client. Whats the matter?

[Former Member · Accepted solution]

Modify Once" field property, It allows you to set the Record field value once. So if you add an empty record, then modify the field and save it, you cannot modify the field again. Or if you add (with the API) a record with the field value set, you cannot modify the value.

Regards,

Ronen

[Former Member]

Thanks Savitri.

This is my case of problem.

[Former Member]

To add on to Ronen's comments, this feature is not fully implemented as of now (SP2 5.5.24.06). Which means, say I add a code of 99 and description of TEST in my table A. Then, if I have Modify Once set to YES on Code, then I should not be able to go and modify the 99 to 100 for that record. However, as of now, you can modify the code to 100.

My understanding is Modify Once will start throwing an error (and will not let you modify the value of that field) starting SP3 (target release towards end of this calendar year).

One last note, Modify Once in my view is a way of enforcing the primary key feature of Oracle that you cannot overwrite a primary key value.

Hope this helps

Savi