Nicolas,
Thank you for the help. I corrected the primary keys and everything is now working. So somehow the table was deleted (don't know by whom) and when I recreated the table, I did not check that the keys were correct as per the programming documentation.
Thanks for the pointers and all the best. This issue is now fixed.
Regards