How to update MTL_RELATED_ITEMS table data for the column END_DATE to Null by using API mtl_related

Hi ,

we are trying to update MTL_RELATED_ITEMS table data for the column END_DATE to null by using  API mtl_related_items_pvt.process_rel_item. While doing this we observed below things.

1. Update script working fine whenever I am passing END_DATE is greater or equals to SYSDATE. But we are not able to modify data through front end for the same record.

     It is showing below error

   

     Error Code: FRM-40654:Record has been updated. Requery the block to see change.

2. we are not able to assign NULL value for the column END_DATE.

I used below script for this.