Hi @kgray @Marcel.Ausan I have found the solution for my issue.It was because the end users have deleted the Work task from the front end but the material lines connected to the work task are not deleted and are visible in MMR lines backend database and those lines are in Open state (but you will not see those lines in front end because of the view condition).So, to close the MMR you need to Close all the MMR lines as these lines are no use we took approval from client to remove those and that's it you can Finish your WO. Dummy scripts to remove the unclosed MMR lines which are present only in backend:DECLARE info_ VARCHAR2(32000); attr_ VARCHAR2 (32000); objid_ VARCHAR2(32000); objversion_ VARCHAR2(32000); cursor get_id is select rowid ,rowversion from IFSAPP.maint_material_req_line_tab where MAINT_MATERIAL_ORDER_NO='MMR_No' and nvl(is_closed,0)=0 ;BEGIN for i in get_id loop ifsapp.Maint_Material_Req_Line_API.remove__(info_ ,i.rowid
Hi All,Thank you for your solutions.Actually for me that option is not visible at all it seems like a bug in our environment.I will check with IFS.Regards,Viraj
Hi @Rashmi Ruth I tried it but its not showing ...Is there any specific Setup which you have done? or it works normally…. Thanks in Advance…. Regards,Viraj
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.