WO not connected to Project error but it is connected to prject

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 ,i.rowversion , 'DO');
   end loop; 
END;

@Marcel.Ausan  If you see my error message, WO number is not showing in my error message because of when we close the WO order the conditions are Work Task and MMR connected to it should be in “Finished” and “Closed” status resp.

Thank you..