Solved

Error while creating PR | IFS_PURCHASE_REQ_LINE_TAB is mutating

  • 10 October 2022
  • 2 replies
  • 151 views

Userlevel 4
Badge +8

Hi, community,

any idea how to get over this error? tried to disable the event however it is not working. any suggestion if I am performing some wrong steps? 

 

Thank you very much in advance.,

icon

Best answer by Chamika Dilhani 10 October 2022, 12:45

View original

2 replies

Userlevel 6
Badge +7

Hi @Hashmit ,

 

Please check this out about avoid mutating table error in IFS event actions.

https://dsj23.me/2021/08/27/tips-to-avoid-mutating-table-error-in-ifs-event-actions/

 

Userlevel 7
Badge +22

Hi @Hashmit 

i had also this issue. Then I did this:

 

DECLARE 
  PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
    
<your code>
 
  COMMIT; /or ROLLBACK;
END;

Reply