We want to insert log record on Shop Order when someone update allocations or operations. I wrote the plsql script but we could not find when the event will trigger?
Best answer by hhy38
View originalWe want to insert log record on Shop Order when someone update allocations or operations. I wrote the plsql script but we could not find when the event will trigger?
Best answer by hhy38
View originalHi,
if your operation updates a column value in shop order can’t you set up history logs against shop_ord_tab ? You can tick the relevant column id on a certain even which is insert, update or delete.
Hi
You are trying to insert a record to History tab when materials and operations are updated in Shop order.
Therefore you can trigger event on below tables.
SHOP_ORDER_OPERATION
SHOP_MATERIAL_ALLOC_TAB.
Regards,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.