Skip to main content

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? 

 

 

PLSQL Script
Event

 

Hi,

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 @hhy38 ,

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,

 


We customized the update revision procedure. It solved our problem.