I have 3 different systems. example sys1, sys2 and sys3
I will get three different files from three different systems. Using those data, one interface program will be updating two custom tables. Using custom tables one interface program will create the sales order.
if two users run the same interface for the diffrent data. while updating custom tables, error message will come like 'user1 is locked by custom table'.
So, here the files are processing one after the other.
I want the solution like, If N number of users processed the interfaces, Files have to process parallel, meaning how the custom tables will be update simultaniously.
Thanks and regards,