how you have made those columns readonly ? using Interface attributes or from the layout ?
Hi Prodipto Tokder,
Thanks for the Response.
I made read only columns at both Layout level and interface level.
I created web adi template with content query.
When I created Excel Template with query retrieved records.
For downloaded records read only functionality is working fine (When I try to change the read only column values Template is erroring out as "read-only fields cannot be changed").
But when I insert new record to Excel template from Menu > Insert > rows or Right click on the line > Insert row, Template is allowing to insert values in read only columns.(I noticed ball symbol(Like "O") is enabling on the column A, when i removed that symbol read only is working. Until that symbol exists template is allowing to insert values in read only columns).
OK, So seems this is how it works... So in that case you can add custom validation for those fields during upload process to restrict it within the Readonly values.
Can you please elaborate.
Custom validation at integrator Uploader level or Package level.
If uploader level could you please elaborate.
Thanks & Regards,
If you are using PL/SQL stored procedure in your Interface then you can write custom logic to handle all such scenarios in your package and can raise it using RAISE_APPLICATION_ERROR. So if your readonly field has value like 'A','B','C' only and someone after entering a new row is trying to insert 'D' against that readonly column then you can handle this condition at the time of the Upload so if you upload then this row will go into red face in the webadi excel with proper custom message like "Only A,B,C is allowed against column XX".
Just make sure your API Returns in Insterface should be "FND Message Code"