Hi,
I’ve got strange problem with state machine. I’m using standard message to change state for selected row (this is master-detail form, state machine defined for master LU):
Sal.SendMsg(Sys.hWndForm, Ifs.Fnd.ApplicationForms.Const.PM_DataRecordStateEvent, Ifs.Fnd.ApplicationForms.Const.METHOD_Execute, ((SalString)"Confirm").ToHandle());
This calls single function from LU: Confirm__. There is no ‘magic’ inside, in Finit_State_Machine___ procedure there is only check if all necessary fields are filled with value. However after calling function application hangs for 15+ minutes (usually, sometimes hangs for longer period of time). I’ve noticed (in Pl/SQL Developer) that there is possible locking problem:
As I mentioned ‘Confirm’ event is really simple – it does not affect any other rows or tables, works on single row in L_CUST_ORD_LINE_PROT_TAB.
Any help, please?
Regards,
/PC